这个update语句要怎么写呢!! 我以前没有用过mysql,好多东西和ms sql不一样,能给出代码吗?谢谢! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 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: 0mysql> select * from t1;+----+---------------+| no | products_info |+----+---------------+| 1 | BOB-12 |+----+---------------+1 row in set (0.00 sec) 关于mysql源码安装的问题 mysql 5.1.50 启动错误 请问:MYsql5 与 瑞星防火墙 冲突?? MYSQL 创建中文表名,以前好使,今天时而好使,时而不好使 求一sql语句 大家看看我的ID设置递增的方法对吗? mysql数据库怎么用一个时间段查询呢?求时间查询的代码 各位帮忙看下一个存储过程问题出在哪 关于mysql 查询问题 怎么修改mysql的root用户名,navicat不能新建连接 >>>建立表格时将多个字段设置为主键的sql语句怎么写??<<<< 在VC下如何连接mysql数据库
-> (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)