mysql清除记录数

1.mysql清空表语句后，新插入的语句会ID会以之前存在的序号记录下去，使用truncate命令清除记录，新插入的语句从1开始 示例： mysql> select id from t1; +----+ | id | +----+ | 1 | | 2 | | 3 | +----+ 清空表 mysql> delete from t1; Query OK, 3 rows affected (0.00 sec) 插入一条数据 mysql> insert into t1 (name) values ('ac4'); 查询ID记录 mysql> select id from t1; +----+ | id | +----+ | 4 | +----+ 利用truncate命令清除记录（如果已有数据会删除） mysql> truncate t1; Query OK, 0 rows affected (0.02 sec) 插入一条数据，再查询看ID mysql> insert into t1 (name) values ('ac6'); mysql> select * from t1; +----+------+ | id | name | +----+------+ | 1 | ac6 | +----+------+ =================================