Delete

删除数据

语法

DELETE FROM <table_name> [WHERE <where_conditions ...>]

目前仅支持单表数据删除，join, 子查询删除现阶段不支持：

DELETE FROM <table_name> JOIN <ref_table_name> ...

DELETE FROM (SELECT ... FROM <table_name>) <alias_table_name>

示例

DELETE FROM student WHERE id > 3

IMPORTANT

DELETE 语句必须在事务内执行，因此现阶段网页控制台与命令行控制台暂不支持 DELETE 语句

Truncate

清空表数据

语法

TRUNCATE [TABLE] <table_name>

类似于

• DELETE FROM <table_name> 但是比此语句快
• DROP TABLE <table_name> and recreate table

执行此语句将会删除表的所有数据，但不会删除表结构，此操作不可逆