MySQL creates tables and sets auto increment of primary keys

mysql创建表:

mysql>创建表用户(
->userid int(4)主键not null auto_increment,
->用户名varchar(16)不为空,
->userpassword varchar(32) not null
-&gt

创建表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
)


Read More: