mysql复习第六天：连接查询

数据表

• student:
  
• class:
  
• score_level
  
• type
  

1、笛卡尔乘积现象

表1有m行，表2有n行，结果m*n行

SELECT * FROM student s,class c;

2、 内连接

等值连接

SELECT s.s_name,c.classname FROM student s,class c WHERE s.class_id = c.classid;

非等值连接

SELECT
  s.s_name,
  s.score,
  l.level
FROM student s,
  score_level l
WHERE s.score BETWEEN l.min
    AND l.max ORDER BY l.level DESC;

自连接

SELECT
  t1.id,
  t1.name     AS '一级',
  t2.parentId,
  t2.name     AS '二级'
FROM TYPE t1,
  TYPE t2
WHERE t1.id = t2.parentId;