微服务跨数据库联合查询_MySQL数据库联合查询

大家好，我是anyux。数据库联表查询很重要，内联查询更是尤为重要。

需要将school.sql文件导入到数据库中

数据库多表联合查询，school库下表的逻辑结构关系都在下图中。可以通过驱动表加子表配合实现所有查询要求。

统计zhang3,学习了几门课

select STU.sname as 姓名, count(SC.sno) as 数量 from student as STU join sc as SC on STU.sno= SC.sno where STU.sname='zhang3';

查询zhang3,学习的课程名称有哪些?

方法1

select STU.sname as 姓名, COU.cname as 课程名  from student as STU join sc as SC on STU.sno = SC.sno join course as COU on SC.cno = COU.cno where STU.sname='zhang3';

方