create table test_del(id int auto_increment,name varchar(10),primary key(id));insert into test_del(name) values(‘xuhao‘),(‘fdsa‘),(‘fddsf‘);create table test_truc(id int auto_increment,name varchar(10),primary key(id));insert into test_truc(name) values(‘xuhao‘),(‘fdsa‘),(‘fddsf‘);

mysql> select * from test_del;+----+-------+| id | name  |+----+-------+|  1 | xuhao ||  2 | fdsa  ||  3 | fddsf |+----+-------+3 rows in setmysql>  select * from test_truc;+----+-------+| id | name  |+----+-------+|  1 | xuhao ||  2 | fdsa  ||  3 | fddsf |+----+-------+3 rows in setmysql> delete from test_del;Query OK, 3 rows affectedmysql> delete from test_truc where true;Query OK, 3 rows affectedmysql> insert into test_del(name) values(‘xuhao‘),(‘fdsa‘),(‘fddsf‘);Query OK, 3 rows affectedRecords: 3  Duplicates: 0  Warnings: 0mysql> insert into test_truc(name) values(‘xuhao‘),(‘fdsa‘),(‘fddsf‘);Query OK, 3 rows affectedRecords: 3  Duplicates: 0  Warnings: 0mysql>  select * from test_del;+----+-------+| id | name  |+----+-------+|  4 | xuhao ||  5 | fdsa  ||  6 | fddsf |+----+-------+3 rows in setmysql>  select * from test_truc;+----+-------+| id | name  |+----+-------+|  4 | xuhao ||  5 | fdsa  ||  6 | fddsf |+----+-------+3 rows in setmysql> truncate test_truc;Query OK, 0 rows affectedmysql> insert into test_truc(name) values(‘xuhao‘),(‘fdsa‘),(‘fddsf‘);Query OK, 3 rows affectedRecords: 3  Duplicates: 0  Warnings: 0mysql> select * from test_truc;+----+-------+| id | name  |+----+-------+|  1 | xuhao ||  2 | fdsa  ||  3 | fddsf |+----+-------+3 rows in set