create table test(id int,name varchar(20));
drop table test;
create table test(
id int not null,
name varchar(20),
primary key(id)
)
insert into test(name,stat) values('123',0);
create table test(
id int not null primary key AUTO_INCREMENT,
stat int,
name varchar(20)
)
delete from test;
select count(*) from test;