Mysql常用命令

入门命令

增删改

建表

use ggteaching;
create table User (
UserID smallint Unsigned zerofill not null AUTO_INCREMENT ,
UserName CHAR(15) not null,
UserPassword CHAR(15) not null,
Gender tinyint Unsigned not null,
Icon Blob not null,
Signature CHAR(20) not null,
IsTeacher bool not null,
primary key(UserID),
unique(UserName )
)engine myisam charset utf8;