CREATE TABLE tb_employee (
id int AUTO_INCREMENT ,
em_serialNumber varchar (30),
em_name char (10) NOT NULL ,
em_sex char (2) NOT NULL ,
em_age int NOT NULL ,
em_IDCard varchar (30) NOT NULL ,
em_born varchar (50) NOT NULL ,
em_nation char (10) NOT NULL ,
em_marriage char (10) NOT NULL ,
em_visage char (10) ,
em_ancestralHome char (30) ,
em_tel varchar (50) ,
em_address varchar (50) ,
em_afterSchool varchar (50) ,
em_speciality varchar (50) ,
em_culture char (10) ,
em_startime char (30) ,
em_departmentId int NOT NULL ,
em_typeWork char (10) ,
em_creatime varchar (50) ,
em_createName char (30) ,
em_bz varchar (50)
)建这样一个表的话,想把em_serialNumber设成主键的话
语句要如何改?
id int AUTO_INCREMENT ,
em_serialNumber varchar (30),
em_name char (10) NOT NULL ,
em_sex char (2) NOT NULL ,
em_age int NOT NULL ,
em_IDCard varchar (30) NOT NULL ,
em_born varchar (50) NOT NULL ,
em_nation char (10) NOT NULL ,
em_marriage char (10) NOT NULL ,
em_visage char (10) ,
em_ancestralHome char (30) ,
em_tel varchar (50) ,
em_address varchar (50) ,
em_afterSchool varchar (50) ,
em_speciality varchar (50) ,
em_culture char (10) ,
em_startime char (30) ,
em_departmentId int NOT NULL ,
em_typeWork char (10) ,
em_creatime varchar (50) ,
em_createName char (30) ,
em_bz varchar (50)
)建这样一个表的话,想把em_serialNumber设成主键的话
语句要如何改?
id int AUTO_INCREMENT ,
em_serialNumber varchar (30),
em_name char (10) NOT NULL ,
em_sex char (2) NOT NULL ,
em_age int NOT NULL ,
em_IDCard varchar (30) NOT NULL ,
em_born varchar (50) NOT NULL ,
em_nation char (10) NOT NULL ,
em_marriage char (10) NOT NULL ,
em_visage char (10) ,
em_ancestralHome char (30) ,
em_tel varchar (50) ,
em_address varchar (50) ,
em_afterSchool varchar (50) ,
em_speciality varchar (50) ,
em_culture char (10) ,
em_startime char (30) ,
em_departmentId int NOT NULL ,
em_typeWork char (10) ,
em_creatime varchar (50) ,
em_createName char (30) ,
em_bz varchar (50),
key auto_id(id),
primary key (em_serialNumber)
);