DDL——学生表——查询表
CREATE TABLE `student` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '学号',
`createDate` datetime DEFAULT NULL,
`userName` varchar(20) DEFAULT NULL,
`pwd` varchar(36) DEFAULT NULL,
`phone` varchar(11) DEFAULT NULL,
`age` tinyint(3) DEFAULT NULL,
`sex` char(2) DEFAULT NULL,
`introduce` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
DML
insert into student values(0,'2024-2-25 10:00:00','王源','123',
'13453453453',24,'男','客厅狂欢。');
insert into student values(0,'2024-2-25 10:00:00','王俊凯','123',
'13453453453',25,'男','重生之门。');
insert into student values(0,'2024-2-25 10:00:00','易烊千玺','123',
'13453453453',24,'男','送你一朵小红花。');
insert into student values(0,'2024-2-25 10:00:00','丁禹兮','123',
'13453453453',29,'男','大理寺少卿游。');
insert into student values(0,'2024-2-25 10:00:00','成毅','123',
'13453453453',34,'男','莲花楼。');
insert into student values(0,'2024-2-25 10:00:00','吴磊','123',
'13453453453',25,'男','星汉灿烂。');
insert into student values(0,'2024-2-25 10:00:00','白敬亭','123',
'13453453453',31,'男','开端。');
insert into result values(0,'政治',96,1);
insert into result values(0,'地理',86,5);
insert into result values(0,'政治',77,3);
insert into result values(0,'英语',99,3);
insert into result values(0,'历史',22,6);
insert into result values(0,'化学',69,2);
insert into result values(0,'Java',79,5);
insert into result values(0,'Java',67,6);
insert into result values(0,'政治',97,2);
insert into result values(0,'物理',76,6);
insert into result values(0,'物理',82,2);
insert into result values(0,'化学',56,4);
DQL
select userName,phone,age,testName,score from student,result
where student.id=result.studentId
ORDER BY score desc;
#笛卡尔积M*N
#多表联合查询—去笛卡尔积操作