1、单表更新
(1)mysql> SELECT * FROM users;
+----+----------+----------+-----+------+
| id | username | password | age | sex |
+----+----------+----------+-----+------+
| 1 | Tom | 123 | 25 | 1 |
| 2 | John | 456 | 25 | 1 |
| 3 | Tom | 123 | 25 | 1 |
| 4 | John | 456 | 16 | 1 |
| 5 | John | 456 | 10 | 1 |
| 10 | John | 456 | 16 | 1 |
| 11 | ROSE | 67 | 10 | 0 |
| 12 | Ben | 456 | 10 | NULL |
+----+----------+----------+--