en:web_development:databases:joins
Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
en:web_development:databases:joins [2021/12/23 07:42] mag created |
en:web_development:databases:joins [2023/08/16 09:33] (current) |
||
|---|---|---|---|
| Line 19: | Line 19: | ||
| | Scarlet Witch | Hero | 1964 | Magic | NULL | NULL | NULL | NULL | | | Scarlet Witch | Hero | 1964 | Magic | NULL | NULL | NULL | NULL | | ||
| - | * < | + | * < |
| ==== Multiple Tables ==== | ==== Multiple Tables ==== | ||
| Line 43: | Line 43: | ||
| * Let's take a look at the second. Click on the table called ' | * Let's take a look at the second. Click on the table called ' | ||
| * Here we see a table with a list of hero/movie pairs. | * Here we see a table with a list of hero/movie pairs. | ||
| + | |||
| + | ==== Unique Index ==== | ||
| + | |||
| * Remember that every table must have a unique index. But in this list, Iron Man and Loki both appear more than once in ' | * Remember that every table must have a unique index. But in this list, Iron Man and Loki both appear more than once in ' | ||
| * Instead, we create a new field that will be unique. By custom, we call it ' | * Instead, we create a new field that will be unique. By custom, we call it ' | ||
en/web_development/databases/joins.1640274165.txt.gz · Last modified: 2023/08/16 09:33 (external edit)
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
