由于用习惯了sqlserver 对Mysql的主键问题不是习惯
经研究发现其结构如下:
drop table if exists `state`;
create table state
(
sid int not null primary key auto_increment,
sname varchar(20) not null
)engine=innodb;
insert into state values(0,'管理员');
insert into state values(0,'vip会员');
insert into state values(0,'会员');
insert into state values(0,'普通用户');
select * from state