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 ??
- ????->?);??
- ???
- ???
- ???
- 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 ??
- );?