mysql第五课

SELECT*FROM student;
+----+------+------+
| id | name | ban  |
+----+------+------+
|  1 | yy   | 1913 |
|  7 | ss   | 1923 |
|  8 | 许   | 1913 |
|  9 | 应   | 1913 |
| 10 | Aron | 1913 |
+----+------+------+
5 rows in set

UPDATE student SET name="yiyq"WHERE ban=1913;
Query OK, 4 rows affected
Rows matched: 4  Changed: 4  Warnings: 0

检查：SELECT*FROM student;
+----+------+------+
| id | name | ban  |
+----+------+------+
|  1 | yiyq | 1913 |
|  7 | ss   | 1923 |
|  8 | yiyq | 1913 |
|  9 | yiyq | 1913 |
| 10 | yiyq | 1913 |
+----+------+------+
5 rows in set

删除数据：SELECT*FROM accout;
+----+------+-------+
| id | name | money |
+----+------+-------+
|  1 | a    |   800 |
|  2 | b    |  1200 |
+----+------+-------+
2 rows in set