Markdown

Markdown学习

二级标题

三级白嫖

sb

导航洒基卡还是不对接你们看到

CREATE TABLE IF NOT EXISTS `student`(
`id` INT(4) NOT NULL AUTO_INCREMENT COMMENT '学号',
`name` VARCHAR(30) NOT NULL DEFAULT '匿名' COMMENT '姓名',
`pwd` VARCHAR(20)  NOT NULL DEFAULT '123456' COMMENT'密码',
`sex` VARCHAR(2) NOT NULL DEFAULT '女' COMMENT '性别',
`birthday` DATETIME DEFAULT NULL COMMENT '出生日期',
`address` VARCHAR(100) DEFAULT NULL COMMENT '家庭地址',
`email` VARCHAR(50) DEFAULT NULL COMMENT '邮箱',
`work` VARCHAR(20) DEFAULT NULL COMMENT '大数据架构师',
PRIMARY KEY(`id`)
)ENGINE=INNODB DEFAULT CHARSET=utf8

SHOW CREATE DATABASE school -- '`student`(`id` INT(4) NOT NULL AUTO_INCREMENT COMMENT '学号',`name` VARCHAR(' at line 1
SHOW CREATE TABLE student 
DESC student

ALTER TABLE teacher RENAME AS teacher1
ALTER TABLE teacher1 ADD age INT(2)

ALTER TABLE teacher1 MODIFY age INT(11)
ALTER TABLE teacher1 CHANGE age age1 INT(2)

ALTER TABLE teacher1 DROP age1