19.修改表中数据

mysql> use oldboy;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> select * from test where id=4; 把 id 号为 4，name=zhangxuan 的更改为 name=pengchun
+----+------+-----------+-------------+
| id | age | name | shouji |
+----+------+-----------+-------------+
| 4 | 24 | zhangxuan | 13511111111 |
+----+------+-----------+-------------+
1 row in set (0.00 sec)
mysql> update test set name=‘pengchun‘ where id=4;
Query OK, 1 row affected (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> select * from test where id=4;
+----+------+----------+-------------+
| id | age | name | shouji |
+----+------+----------+-------------+
| 4 | 24 | pengchun | 13511111111 |
+----+------+----------+-------------+
1 row in set (0.00 sec)?