Please enable JavaScript.
Coggle requires JavaScript to display documents.
SQL总结 (join (inner join（join默认为inner join） (SELECT * FROM table1 JOIN…
SQL总结
join
inner join（join默认为inner join）
SELECT * FROM table1 JOIN table2 ON table2.name = table1.name
table1与table2的交集
left outer join
SELECT * FROM table1 RIGHT OUTER JOIN table2 ON table2.name = table1.name
table1的集合
right outer join
SELECT * FROM table1 RIGHT OUTER JOIN table2 ON table2.name = table1.name
table2的集合
cross join
SELECT * FROM table1 CROSS JOIN table2
笛卡尔积
full outer join
产生table1与table2的并集（Mysql不支持）
union
UNION（去重）
SELECT * FROM table1 UNION SELECT id,name FROM table2
:warning:必须保证select中的列的长度和数据类型一致
UNION ALL(不去重)