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

posted on 2023-02-01 11:32  夜黎i  阅读(41)  评论(0)    收藏  举报

导航