--注释
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
标签:COMMENT,engine,VARCHAR,DEFAULT,创建,innodb,sql,NULL,2.4 From: https://www.cnblogs.com/zhenlee/p/17874738.html