15,017
edits
Visual explanation of MySQL joins: Difference between revisions
Jump to navigation
Jump to search
→狀況1: 交集的資料
(Created page with "使用維恩圖(Venn diagram)視覺化解釋 MySQL Join == 準備測試資料 == <pre> CREATE TABLE table_a (id int NOT NULL PRIMARY KEY, name varchar(30) CHARACTER SET utf...") |
|||
| Line 56: | Line 56: | ||
INNER JOIN table_b | INNER JOIN table_b | ||
ON table_a.id = table_b.id; | ON table_a.id = table_b.id; | ||
/*相同效果的別種寫法*/ | |||
SELECT * FROM table_a, table_b WHERE table_a.id = table_b.id; | |||
SELECT a.*, b.* FROM table_a AS a NATURAL JOIN table_b AS b; | |||
</pre> | </pre> | ||