mysql 基础命令

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;