--注释
varchat
default
comment
engine=innodb
engine=innodb
engine=innodb
auto_increment
CREATE TABLE IF NOT EXISTS student (
`id` INT(8) NOT NULL AUTO_INCREMENT COMMENT '学号',
`pwd` VARCHAR(32) NOT NULL DEFAULT '123456' COMMENT '密码',
`name` VARCHAR(32) NOT NULL COMMENT '名字',
`address` VARCHAR(60) NOT NULL COMMENT '地址',
`email` VARCHAR(100) DEFAULT NULL COMMENT '邮箱',
PRIMARY KEY(`id`)
)ENGINE=INNODB DEFAULT CHARSET=utf8