一样可以的,见下例:
mysql> create table aa (id varchar(20) not null,name varchar(30));
Query OK, 0 rows affected (0.13 sec)mysql> insert into aa values('1','aa'),('2','bb'),('3','cc'),('7','dd');
Query OK, 4 rows affected (0.01 sec)
Records: 4 Duplicates: 0 Warnings: 0mysql> select * from aa;
+----+------+
| id | name |
+----+------+
| 1 | aa |
| 2 | bb |
| 3 | cc |
| 7 | dd |
+----+------+
4 rows in set (0.00 sec)mysql> update aa set id=id+1;
Query OK, 4 rows affected (0.00 sec)
Rows matched: 4 Changed: 4 Warnings: 0mysql> select * from aa;
+----+------+
| id | name |
+----+------+
| 2 | aa |
| 3 | bb |
| 4 | cc |
| 8 | dd |
+----+------+
4 rows in set (0.00 sec)
mysql> create table aa (id varchar(20) not null,name varchar(30));
Query OK, 0 rows affected (0.13 sec)mysql> insert into aa values('1','aa'),('2','bb'),('3','cc'),('7','dd');
Query OK, 4 rows affected (0.01 sec)
Records: 4 Duplicates: 0 Warnings: 0mysql> select * from aa;
+----+------+
| id | name |
+----+------+
| 1 | aa |
| 2 | bb |
| 3 | cc |
| 7 | dd |
+----+------+
4 rows in set (0.00 sec)mysql> update aa set id=id+1;
Query OK, 4 rows affected (0.00 sec)
Rows matched: 4 Changed: 4 Warnings: 0mysql> select * from aa;
+----+------+
| id | name |
+----+------+
| 2 | aa |
| 3 | bb |
| 4 | cc |
| 8 | dd |
+----+------+
4 rows in set (0.00 sec)
解决方案 »
- a later version of mysql server 5.5 is already installed
- SQL没触发到索引
- VC中通过MYSQL C API调用返回结果集的存储过程失败,见内
- mysql报错了。。
- mysql5.1服务启动不了,实分郁闷
- select里怎么写判断语句?
- MYSQL 什么语句可以查看表中的所有索引名
- Applet jdbc mysql
- 菜鸟求救:我运行 ./mysqladmin -u root -p password '你的新密码'有问题
- 用了order by以后数据查询特别慢,帮我看下吧
- 大家都用那个版本的MYSQL以及MYSQL的升级问题
- 我从数据库中读出来的都是一种代替中文的乱码,怎样把它还原成中文
mysql> select * from aa;
+----+------+
| id | name |
+----+------+
| 2 | aa |
| 3 | ee |
| 4 | cc |
| 8 | dd |
+----+------+
4 rows in set (0.00 sec)mysql> update aa set name=concat(name,'ee') where id='3';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0mysql> select * from aa;
+----+------+
| id | name |
+----+------+
| 2 | aa |
| 3 | eeee |
| 4 | cc |
| 8 | dd |
+----+------+
4 rows in set (0.00 sec)
这两种不知道有没有是你想要的,没有的话,就真的很抱赚帮不了你。