15,059
edits
Visual explanation of MySQL joins: Difference between revisions
Jump to navigation
Jump to search
m
no edit summary
mNo edit summary |
|||
| Line 2: | Line 2: | ||
== 準備測試資料 == | == 準備測試資料 == | ||
兩個資料表的 id 欄位都是主鍵( [http://www.w3schools.com/sql/sql_primarykey.asp PRIMARY KEY] )。 | |||
<pre> | <pre> | ||
CREATE TABLE table_a (id int NOT NULL PRIMARY KEY, name varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL); | CREATE TABLE table_a (id int NOT NULL PRIMARY KEY, name varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL); | ||
| Line 26: | Line 27: | ||
=== 預覽測試資料 === | === 預覽測試資料 === | ||
兩個資料表都有的資料，以紅色標示: | |||
<table> | <table> | ||
<tr> | <tr> | ||