数据库DML语言---DELETE 语句

DELETE 语句

使用 DELETE 语句从表中删除数据。

DELETE [FROM]   table

[WHERE   condition];

删除数据

使用WHERE 子句指定删除的记录。
DELETE FROM departments

 WHERE  department_name = 'Finance';

1 row deleted.

 

DELETE FROM  copy_emp;

22 rows deleted.

 

如果省略WHERE子句，则表中的全部数据将被删除。

 

 

在 DELETE 中使用子查询

在 DELETE 中使用子查询，使删除基于另一个表中的数据。

 

DELETE FROM employees

WHERE  department_id =

                       (SELECT department_id

                        FROM   departments

                        WHERE  department_name LIKE '%Public%');

1 row deleted.