可以使用 DELETE 语句删除数据。

格式

删除数据常用操作的语法如下：

DELETE FROM tblname  
       [WHERE where_condition]

DELETE 语句中如果不带 WHERE 条件，则表示删除全部数据。

示例

DELETE FROM employee WHERE personid>=100;
Query OK, 2 rows affected (0.01 sec)
SELECT * FROM employee WHERE personid>=100;
Empty set (0.00 sec)