修改数据(update)
update 表名 set 字段名1 = 值1 ,字段名2 = 值2,...[where 条件];
修改id为1的数据,把名字修改成邓先生
mysql> update abc set name = '邓先生' where id =1;
Query OK, 1 row affected (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> select * from abc;
+------+--------+------+
| id | name | age |
+------+--------+------+
| 1 | 邓先生 | 13 |
| 2 | 李四 | 19 |
| 3 | 王五 | 19 |
| 4 | 赵六 | 29 |
+------+--------+------+
4 rows in set (0.00 sec)
将所有人的年龄修改成18
mysql> UPDATE abc SET age = 18;
Query OK, 4 rows affected (0.01 sec)
Rows matched: 4 Changed: 4 Warnings: 0
mysql> select * from abc;
+------+--------+------+
| id | name | age |
+------+--------+------+
| 1 | 邓先生 | 18 |
| 2 | 李四 | 18 |
| 3 | 王五 | 18 |
| 4 | 赵六 | 18 |
+------+--------+------+
4 rows in set (0.00 sec)
将id = 1 的人的名字年龄修改成 ‘陈先生’,20
mysql> UPDATE abc SET name = '陈先生',age = 20 where id = 1;
Query OK, 1 row affected (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> select * from abc;
+------+--------+------+
| id | name | age |
+------+--------+------+
| 1 | 陈先生 | 20 |
| 2 | 李四 | 18 |
| 3 | 王五 | 18 |
| 4 | 赵六 | 18 |
+------+--------+------+
4 rows in set (0.00 sec)
修改语句的where条件可以有,如果没有那就是修改整张表的所有数据