MySQL-50道经典sql题汇总.pdf
文本预览下载声明
MySQL-50道经典sql题汇总题⽬是根据⾃⼰的理解做的，都能跑出来，但是肯定还有不⾜之处，欢迎⼤
家提出问题，⼀起研究学习建表
DROP TABLE IF EXISTS `course`;
CREATE TABLE `course` (
`CId` varchar(10) default NULL,
`Cname` varchar(10) default NULL,
`TId` varchar(10) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Table structure for sc
--
DROP TABLE IF EXISTS `sc`;
CREATE TABLE `sc` (
`SId` varchar(10) default NULL,
`CId` varchar(10) default NULL,
`score` int(4) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Table structure for student
--
DROP TABLE IF EXISTS `student`;
CREATE TABLE `student` (
`SId` varchar(10) default NULL,
`Sname` varchar(20) default NULL,
`Sage` date default NULL,
`Ssex` varchar(10) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Table structure for teacher
--
DROP TABLE IF EXISTS `teacher`;
CREATE TABLE `teacher` (
`TId` varchar(10) default NULL,
`Tname` varchar(20) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
添加数据
course
INSERT INTO `course` VALUES (01, CHINESE, 02);
INSERT INTO `course` VALUES (02, MATH, 01);
INSERT INTO `course` VALUES (03, ENGLISH, 03);
INSERT INTO `course` VALUES (04, JAVA, 04);
sc
INSERT INTO `sc` VALUES (01, 01, 80);
INSERT INTO `sc` VALUES (01, 03, 99);
INSERT INTO `sc` VALUES (02, 04, 50);
INSERT INTO `sc` VALUES (02, 03, 80);
INSERT INTO `sc` VALUES (03, 01, 80);
INSERT INTO `sc` VALUES (03, 03, 80);
INSERT INTO `sc` VALUES (04, 01, 50);
INSERT INTO `sc` VALUES (04, 03, 20);
INSERT INTO `sc` VALUES (05, 01, 100);
INSERT INTO `sc` VALUES (06, 01, 31);
INSERT INTO `sc` VALUES (06, 03, 34);
INSERT INTO `sc` VALUES (07, 03, 98);
INSERT INTO `sc` VALUES (07, 04, 55);
INSERT INTO `sc` VALUES (01, 04, 50);
INSERT INTO `sc` VALUES (01, 02, 10);
INSERT INTO `sc` VALUES (02, 02, 70);
INSERT INTO `sc` VALUES (03, 02, 50);
INSERT INTO `sc` VALUES (04, 02, 80);
INSERT INTO `sc` VALUES (05, 02, 73);
INSERT INTO `sc` VALUES (06, 02, 99);
INSERT INTO `sc` VALUES (07, 02, 100);
INSERT INTO `sc
显示全部