mysql 創建表並設置主鍵自增
mysql 創建表:
mysql> create table user(
-> userid int ( 4 ) primary key not null auto_increment,
-> username varchar(16 ) not null ,
-> userpassword varchar(32 ) not null
-> ); www.2cto.com
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
);
作者 fanjf