建表
![](https://i-blog.csdnimg.cn/blog_migrate/8f900a89c6347c561fdf2122f13be562.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/961ddebeb323a10fe0623af514929fc1.gif)
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;