删

删除表

DROP TABLE student;

删除students数据库

DROP DATABASE students;

截断表(一次性的删除表的所有数据)

TRUNCATE TABLE student;

清空表数据(一条一条的删除表数据)

DELETE FROM student;

删除某个数据

DELETE FROM student WHERE id = 101;