SQL基础(四)--update

将表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