将表t_person中所有人员的FREMARK字段值更新为“SuperMan”
mysql> update t_person
-> set fremark='SuperMan';
Query OK, 7 rows affected
Rows matched: 7 Changed: 7 Warnings: 0
mysql> select * from t_person;
+----------+------+----------+
| fname | fage | fremark |
+----------+------+----------+
| Iurenl | 23 | SuperMan |
| Jim | 20 | SuperMan |
| Kimi | 21 | SuperMan |
| Lili | 22 | SuperMan |
| LXF | 22 | SuperMan |
| Tom | 18 | SuperMan |
| XiaoWang | 17 | SuperMan |
+----------+------+----------+
7 rows in set
将表t_person中所有人员的FREMARK字段和FAGE字段的值分别改为“Sonic”、25
mysql> update t_person
-> set
-> fage=25,
-> fremark='Sonic';
Query OK, 7 rows affected
Rows matched: 7 Changed: 7 Warnings: 0
mysql> select * from t_person;
+----------+------+---------+
| fname | fage | fremark |
+----------+------+---------+
| Iurenl | 25 | Sonic |
| Jim | 25 | Sonic |
| Kimi | 25 | Sonic |
| Lili | 25 | Sonic |
| LXF | 25 | Sonic |
| Tom | 25 | Sonic |
| XiaoWang | 25 | Sonic |
+----------+------+---------+
7 rows in set
将Tom的年龄改为12岁
mysql> update t_person
-> set fage=12
-> where fname='Tom';
Query OK, 1 row affected
Rows matched: 1 Changed: 1 Warnings: 0
mysql> select * from t_person;
+----------+------+---------+
| fname | fage | fremark |
+----------+------+---------+
| Iurenl | 25 | Sonic |
| Jim | 25 | Sonic |
| Kimi | 25 | Sonic |
| Lili | 25 | Sonic |
| LXF | 25 | Sonic |
| Tom | 12 | Sonic |
| XiaoWang | 25 | Sonic |
+----------+------+---------+
7 rows in set
将所有年龄为25的人员备注信息修改为“BlaBla”
mysql> update t_person
-> set fremark='BlaBla'
-> where fage=25;
Query OK, 6 rows affected
Rows matched: 6 Changed: 6 Warnings: 0
mysql> select * from t_person;
+----------+------+---------+
| fname | fage | fremark |
+----------+------+---------+
| Iurenl | 25 | BlaBla |
| Jim | 25 | BlaBla |
| Kimi | 25 | BlaBla |
| Lili | 25 | BlaBla |
| LXF | 25 | BlaBla |
| Tom | 12 | Sonic |
| XiaoWang | 25 | BlaBla |
+----------+------+---------+
7 rows in set
将FNAME等于“Jim”或者“LXF”的行的Fage字段值修改为22
mysql> update t_person
-> set fage=22
-> where fname='Jim' or fname='LXF';
Query OK, 2 rows affected
Rows matched: 2 Changed: 2 Warnings: 0
mysql> select * from t_person;
+----------+------+---------+
| fname | fage | fremark |
+----------+------+---------+
| Iurenl | 25 | BlaBla |
| Jim | 22 | BlaBla |
| Kimi | 25 | BlaBla |
| Lili | 25 | BlaBla |
| LXF | 22 | BlaBla |
| Tom | 12 | Sonic |
| XiaoWang | 25 | BlaBla |
+----------+------+---------+
7 rows in set