Visual explanation of MySQL joins: Difference between revisions
Jump to navigation
Jump to search
← Older edit
Newer edit →
Visual explanation of MySQL joins
(edit)
Revision as of 21:30, 31 October 2015
50 bytes added
,
31 October 2015
m
→預覽測試資料
Revision as of 17:13, 30 October 2015
(
edit
)
Planetoid
(
talk
|
contribs
)
(
→預覽測試資料
)
← Older edit
Revision as of 21:30, 31 October 2015
(
edit
)
(
undo
)
Planetoid
(
talk
|
contribs
)
m
(
→預覽測試資料
)
Newer edit →
Line 26:
Line 26:
=== 預覽測試資料 ===
=== 預覽測試資料 ===
兩個資料表的 id 欄位都是 PRIMARY
KEY。兩個資料表都有的資料,以紅色標示
:
兩個資料表的 id 欄位都是
[http://www.w3schools.com/sql/sql_primarykey.asp
PRIMARY
KEY]。兩個資料表都有的資料,以紅色標示
:
<table>
<table>
<tr>
<tr>
Planetoid
Bureaucrats
,
Administrators
15,017
edits
Navigation menu
Personal tools
Not logged in
Talk
Contributions
Log in
Namespaces
Page
Discussion
English
Views
Read
Edit
View history
More
Search
Navigation
Main page
Current events
Recent changes
Random page
Help
Categories
Tools
Special pages
Printable version