MySQL 插入、更新与删除数据

8.1 插入数据
INSER INTO的各种插入法

8.2 更新数据
UPDATE可以更新表中的记录。基本句法如下：

UPDATE table_name
SET column_name1=value1,column_name1=value2,...
WHERE(condition);

例：对第七章中的employee表，更新e_no=1001的记录，将e_name改为LiMing。

mysql> UPDATE employee SET e_name='LiMing' WHERE e_no=1001;
Query OK, 1 row affected (0.19 sec)
Rows matched: 1  Changed: 1  Warnings: 0

8.3 删除数据
DELETE语句基本语法格式：

DELETE FROM table_name [WHERE <condition>]

例：删除employee表中e_no=1001的记录：

mysql> SELECT * FROM employee WHERE e_no=1001;
+------+--------+----------+---------+-------+----------+------------+
| e_no | e_name | e_gender | dept_no | e_job | e_salary | hireDate   |
+------+--------+----------+---------+-------+----------+------------+
| 1001 | LiMing | m        |      20 | CLERK |      800 | 2005-11-12 |
+------+--------+----------+---------+-------+----------+------------+
1 row in set (0.00 sec)

mysql> DELETE FROM employee WHERE e_no=1001;
Query OK, 1 row affected (0.15 sec)

mysql> SELECT * FROM employee WHERE e_no=1001;
Empty set (0.00 sec)