08删除数据

1.用DELETE命令删除数据

DELETE [FROM] table_name [WHILE CONDITION_EXPRESSION]

示例：删除性别为女的玩家记录

---

DELETE from users where user_sex = "女"

---

2.使用truncate table删除数据

truncate table table_name

注意：删除的是表中所有数据。