12.删除数据

12.1 DELETE

delete from 表名字 [ WHERE id = 8]

-- 整张表清除数据
DELETE FROM USER 
-- 可以使用where条件限定删除的范围
delete from user where id = 8

12.2 TRUNCATE

TRUNCATE 表名

跟delete 的区别: 不会记录日志。