1、删除所有记录
DELETE FROM tbl_name;
2、删除指定记录
自增长值不变
DELETE FROM tbl_name WHERE 条件;
mysql> -- 删除指定记录mysql> DELETE FROM user WHERE id=5;Query OK, 1 row affected (0.05 sec)
mysql> SELECT * FROM user;+----+----------+------+| id | username | age |+----+----------+------+| 1 | 张三 | 45 || 2 | 长一岁 | 16 || 6 | 张1 | 21 || 7 | 张2 | 22 || 8 | 张3 | 23 || 9 | 大大 | 88 |+----+----------+------+
3、彻底清空表(TRUNCATE)
自增长值会变为初始值
TRUNCATE [TABLE] tbl_name;