说明: 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)
<sinat_32785745> 上传 | 大小:819byte