Mysql-几张供于学习的表
CREATE TABLE `student` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(30) NOT NULL,
`high` decimal(5,2) DEFAULT NULL,
`gender` enum('男','女','保密') DEFAULT '保密',
`cls_id` int(11) DEFAULT NULL,
`is_delete` bit(1) DEFAULT b'0',
`age` int(10) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;
CREATE TABLE `classess` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(30) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
CREATE TABLE `areas` (
`aid` varchar(30) NOT NULL,
`atitle` varchar(30) DEFAULT NULL,
`pid` varchar(30) DEFAULT NULL,
PRIMARY KEY (`aid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
需要自取:链接:https://pan.baidu.com/s/1FpuyTi2PgM_lqo3BjVao1g?pwd=33ss
提取码:33ss