【文件属性】:
文件名称:mysql清除记录数
文件大小:819B
文件格式:TXT
更新时间:2018-12-03 10:26:34
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 |
+----+------+
=================================