mysql数据库表主键自增长的sql语句1、不控制主键的起点create table emb_t_dictBusType (
emb_c_busTypeID int not null auto_increment,
emb_c_busTypeEnName varchar(255) not null,
emb_c_busTypeZhName varchar(255) not null,
primary key(emb_c_busTypeID))engine=INNODB default charset=gbk;
2、控制主键的起点create table emb_t_dictBusType (
emb_c_busTypeID int not null auto_increment,
emb_c_busTypeEnName varchar(255) not null,
emb_c_busTypeZhName varchar(255) not null,
primary key(emb_c_busTypeID))engine=INNODB auto_increment=1001 default charset=gbk;