Mysql creates a table and sets the primary key auto-incrementing _ MySQL

Mysql creates a table and sets the primary key auto-incrementing bitsCN.com
Mysql creates a table and sets primary key auto-incrementing mysql tables: mysql> create table user (-> userid int (4) primary key not null auto_increment,-> username varchar (16) not null,-> userpassword varchar (32) not null->); create table log (logid int (4) primary key not null auto_increment, logtitle varchar (32) not null, logcontent varchar (160) not null, logtime datetime not null, userip varchar (64) not null); author: fanjfbitsCN.com