56,677
社区成员
发帖
与我相关
我的任务
分享这个update语句要怎么写呢！！
表t1中的一个字段products_info，它里面的值是小写的字母+数字如：bob01
怎样把它转化为 BOB-01，谢谢！
怎样把它转化为 BOB-01，谢谢！
...全文
请发表友善的回复…
发表回复
evilks 2004-06-28
- 打赏
- 举报
Thank you!
黄有才 2004-06-27
- 打赏
- 举报
mysql> create table t1
-> (no int not null,products_info varchar(10));
Query OK, 0 rows affected (0.03 sec)
mysql> select * from t1;
+----+---------------+
| no | products_info |
+----+---------------+
| 1 | bob01 |
+----+---------------+
1 row in set (0.00 sec)
mysql> update t1
-> set products_info=concat(ucase(left(products_info,3)),'-',right(products_
info,2));
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> select * from t1;
+----+---------------+
| no | products_info |
+----+---------------+
| 1 | BOB-12 |
+----+---------------+
1 row in set (0.00 sec)
-> (no int not null,products_info varchar(10));
Query OK, 0 rows affected (0.03 sec)
mysql> select * from t1;
+----+---------------+
| no | products_info |
+----+---------------+
| 1 | bob01 |
+----+---------------+
1 row in set (0.00 sec)
mysql> update t1
-> set products_info=concat(ucase(left(products_info,3)),'-',right(products_
info,2));
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> select * from t1;
+----+---------------+
| no | products_info |
+----+---------------+
| 1 | BOB-12 |
+----+---------------+
1 row in set (0.00 sec)
evilks 2004-06-26
- 打赏
- 举报
我以前没有用过mysql，好多东西和ms sql不一样，能给出代码吗？谢谢！
zpa 2004-06-26
- 打赏
- 举报
用字符串分割
evilks 2004-06-26
- 打赏
- 举报
啊，居然没有人理我啊！！帮帮忙哦！
