mysql join不加关联条件的含义

select * from student,course;

+----+------+----------+-----+----+------+----+
|s_id|s_name|s_birth   |s_sex|c_id|c_name|t_id|
+----+------+----------+-----+----+------+----+
|01  |赵雷    |1990-01-01|男    |01  |语文    |02  |
|01  |赵雷    |1990-01-01|男    |02  |数学    |01  |
|01  |赵雷    |1990-01-01|男    |03  |英语    |03  |
|02  |钱电    |1990-12-21|男    |01  |语文    |02  |
|02  |钱电    |1990-12-21|男    |02  |数学    |01  |
|02  |钱电    |1990-12-21|男    |03  |英语    |03  |
|03  |孙风    |1990-05-20|男    |01  |语文    |02  |
|03  |孙风    |1990-05-20|男    |02  |数学    |01  |
|03  |孙风    |1990-05-20|男    |03  |英语    |03  |
|04  |李云    |1990-08-06|男    |01  |语文    |02  |
|04  |李云    |1990-08-06|男    |02  |数学    |01  |
|04  |李云    |1990-08-06|男    |03  |英语    |03  |
|05  |周梅    |1991-12-01|女    |01  |语文    |02  |
|05  |周梅    |1991-12-01|女    |02  |数学    |01  |
|05  |周梅    |1991-12-01|女    |03  |英语    |03  |
|06  |吴兰    |1992-03-01|女    |01  |语文    |02  |
|06  |吴兰    |1992-03-01|女    |02  |数学    |01  |
|06  |吴兰    |1992-03-01|女    |03  |英语    |03  |
|07  |郑竹    |1989-07-01|女    |01  |语文    |02  |
|07  |郑竹    |1989-07-01|女    |02  |数学    |01  |
|07  |郑竹    |1989-07-01|女    |03  |英语    |03  |
|08  |王菊    |1990-01-20|女    |01  |语文    |02  |
|08  |王菊    |1990-01-20|女    |02  |数学    |01  |
|08  |王菊    |1990-01-20|女    |03  |英语    |03  |
+----+------+----------+-----+----+------+----+

上述写法等价于

select * from student join course;
+----+------+----------+-----+----+------+----+
|s_id|s_name|s_birth   |s_sex|c_id|c_name|t_id|
+----+------+----------+-----+----+------+----+
|01  |赵雷    |1990-01-01|男    |01  |语文    |02  |
|01  |赵雷    |1990-01-01|男    |02  |数学    |01  |
|01  |赵雷    |1990-01-01|男    |03  |英语    |03  |
|02  |钱电    |1990-12-21|男    |01  |语文    |02  |
|02  |钱电    |1990-12-21|男    |02  |数学    |01  |
|02  |钱电    |1990-12-21|男    |03  |英语    |03  |
|03  |孙风    |1990-05-20|男    |01  |语文    |02  |
|03  |孙风    |1990-05-20|男    |02  |数学    |01  |
|03  |孙风    |1990-05-20|男    |03  |英语    |03  |
|04  |李云    |1990-08-06|男    |01  |语文    |02  |
|04  |李云    |1990-08-06|男    |02  |数学    |01  |
|04  |李云    |1990-08-06|男    |03  |英语    |03  |
|05  |周梅    |1991-12-01|女    |01  |语文    |02  |
|05  |周梅    |1991-12-01|女    |02  |数学    |01  |
|05  |周梅    |1991-12-01|女    |03  |英语    |03  |
|06  |吴兰    |1992-03-01|女    |01  |语文    |02  |
|06  |吴兰    |1992-03-01|女    |02  |数学    |01  |
|06  |吴兰    |1992-03-01|女    |03  |英语    |03  |
|07  |郑竹    |1989-07-01|女    |01  |语文    |02  |
|07  |郑竹    |1989-07-01|女    |02  |数学    |01  |
|07  |郑竹    |1989-07-01|女    |03  |英语    |03  |
|08  |王菊    |1990-01-20|女    |01  |语文    |02  |
|08  |王菊    |1990-01-20|女    |02  |数学    |01  |
|08  |王菊    |1990-01-20|女    |03  |英语    |03  |
+----+------+----------+-----+----+------+----+

也等价于

select * from student cross  join course;
+----+------+----------+-----+----+------+----+
|s_id|s_name|s_birth   |s_sex|c_id|c_name|t_id|
+----+------+----------+-----+----+------+----+
|01  |赵雷    |1990-01-01|男    |01  |语文    |02  |
|01  |赵雷    |1990-01-01|男    |02  |数学    |01  |
|01  |赵雷    |1990-01-01|男    |03  |英语    |03  |
|02  |钱电    |1990-12-21|男    |01  |语文    |02  |
|02  |钱电    |1990-12-21|男    |02  |数学    |01  |
|02  |钱电    |1990-12-21|男    |03  |英语    |03  |
|03  |孙风    |1990-05-20|男    |01  |语文    |02  |
|03  |孙风    |1990-05-20|男    |02  |数学    |01  |
|03  |孙风    |1990-05-20|男    |03  |英语    |03  |
|04  |李云    |1990-08-06|男    |01  |语文    |02  |
|04  |李云    |1990-08-06|男    |02  |数学    |01  |
|04  |李云    |1990-08-06|男    |03  |英语    |03  |
|05  |周梅    |1991-12-01|女    |01  |语文    |02  |
|05  |周梅    |1991-12-01|女    |02  |数学    |01  |
|05  |周梅    |1991-12-01|女    |03  |英语    |03  |
|06  |吴兰    |1992-03-01|女    |01  |语文    |02  |
|06  |吴兰    |1992-03-01|女    |02  |数学    |01  |
|06  |吴兰    |1992-03-01|女    |03  |英语    |03  |
|07  |郑竹    |1989-07-01|女    |01  |语文    |02  |
|07  |郑竹    |1989-07-01|女    |02  |数学    |01  |
|07  |郑竹    |1989-07-01|女    |03  |英语    |03  |
|08  |王菊    |1990-01-20|女    |01  |语文    |02  |
|08  |王菊    |1990-01-20|女    |02  |数学    |01  |
|08  |王菊    |1990-01-20|女    |03  |英语    |03  |
+----+------+----------+-----+----+------+----+

select * from student inner  join course;
+----+------+----------+-----+----+------+----+
|s_id|s_name|s_birth   |s_sex|c_id|c_name|t_id|
+----+------+----------+-----+----+------+----+
|01  |赵雷    |1990-01-01|男    |01  |语文    |02  |
|01  |赵雷    |1990-01-01|男    |02  |数学    |01  |
|01  |赵雷    |1990-01-01|男    |03  |英语    |03  |
|02  |钱电    |1990-12-21|男    |01  |语文    |02  |
|02  |钱电    |1990-12-21|男    |02  |数学    |01  |
|02  |钱电    |1990-12-21|男    |03  |英语    |03  |
|03  |孙风    |1990-05-20|男    |01  |语文    |02  |
|03  |孙风    |1990-05-20|男    |02  |数学    |01  |
|03  |孙风    |1990-05-20|男    |03  |英语    |03  |
|04  |李云    |1990-08-06|男    |01  |语文    |02  |
|04  |李云    |1990-08-06|男    |02  |数学    |01  |
|04  |李云    |1990-08-06|男    |03  |英语    |03  |
|05  |周梅    |1991-12-01|女    |01  |语文    |02  |
|05  |周梅    |1991-12-01|女    |02  |数学    |01  |
|05  |周梅    |1991-12-01|女    |03  |英语    |03  |
|06  |吴兰    |1992-03-01|女    |01  |语文    |02  |
|06  |吴兰    |1992-03-01|女    |02  |数学    |01  |
|06  |吴兰    |1992-03-01|女    |03  |英语    |03  |
|07  |郑竹    |1989-07-01|女    |01  |语文    |02  |
|07  |郑竹    |1989-07-01|女    |02  |数学    |01  |
|07  |郑竹    |1989-07-01|女    |03  |英语    |03  |
|08  |王菊    |1990-01-20|女    |01  |语文    |02  |
|08  |王菊    |1990-01-20|女    |02  |数学    |01  |
|08  |王菊    |1990-01-20|女    |03  |英语    |03  |
+----+------+----------+-----+----+------+----+

总结

• 不加关联条件时, , = join = cross join = inner join
• 也就是说 不加关联条件时,一律都是笛卡尔积, (left join与right join 除外)
• 因为没有关联条件,所以此处的join,cross join并不是求交集的含义