语法

delete from 表名 where 筛选条件

实例

delete from student where `id`= 7;

语法

truncate table 表名

实例

truncate table student;