无条件全表删除

语法

  1. DELETE FROM 表名;

例子

delete from my_teacher;

带条件删除

语法

DELETE FROM 表名 WHERE 条件;

例子

delete from my_teacher where id = 13;

truncate删除

语法
truncate 表示清空表的结构和数据

TRUNCATE TABLE 表名;

例子

truncate table my_teacher;