更新数据
1、在更新数据的时候,特别要注意:通常一定是跟随条件更新
update 表名 set 字段名 = 新值 where 判断条件;
2、如果没有条件,是全表更新数据,但是可以使用limit来显示更新的数量:
update 表名 set 字段名 = 新值 [where 判断条件] limit 数量;
mysql> select * from copy_table;
+------+
| name |
+------+
| a |
| b |
| c |
| d |
| a |
| b |
| c |
| d |
| a |
| b |
| c |
| d |
| a |
| b |
| c |
| d |
+------+
16 rows in set (0.16 sec)
mysql> update copy_table set name='good' where name='a' limit 2;
Query OK, 2 rows affected (0.12 sec)
Rows matched: 2 Changed: 2 Warnings: 0
mysql> select * from copy_table;
+------+
| name |
+------+
| good |
| b |
| c |
| d |
| good |
| b |
| c |
| d |
| a |
| b |
| c |
| d |
| a |
| b |
| c |
| d |
+------+
16 rows in set (0.00 sec)