CREATE TABLE pjw_user
(
userId
int(10) unsigned NOT NULL AUTO_INCREMENT,
userName
varchar(15) NOT NULL,
password
varchar(15) NOT NULL,
sex
int(11) NOT NULL,
Identity
varchar(18) NOT NULL,
birth
date NOT NULL,
telPhone
varchar(11) NOT NULL,
adds
varchar(255) NOT NULL,
email
varchar(25) NOT NULL,
PRIMARY KEY (userId
)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
insert into pjw_user values(NULL,“dssad”,“4554”,0,“365522565422325”,“2015-05-03”,“411744154”,“gfhfgh”,“114555@qq.com”);