准备2 张表
CREATE TABLE `sc` (
`SId` varchar(10) DEFAULT NULL,
`CId` varchar(10) DEFAULT NULL,
`score` decimal(18,1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `student` (
`SId` varchar(10) DEFAULT NULL,
`Sname` varchar(10) DEFAULT NULL,
`Sage` datetime DEFAULT NULL,
`Ssex` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
from 表1,表2 与join的区别
1、from多表
SELECT * FROM student,sc where student.SId=sc.SId
2、join
SELECT* FROM student JOIN sc on student.SId=sc.SId
总结:执行结果是一样的,执行效率也是才不多的
ON后面多条件 与 where 多条件
SELECT * FROM student,sc where student.SId=sc.SId and student.SId IN (01,02,03)
SELECT* FROM student JOIN sc on student.SId=sc.SId and student.SId IN (01,02,03)
结论:on后面多条件与 where 后面多条件结果一致