databases/
Tables, queries, indexes, transactions, storage engines and caching.
2 results
databases/sql-joins-how-two-tables-become-one-answer-inner-left-right-full.md
SQL JOINs: how two tables become one answer (INNER, LEFT, RIGHT, FULL)
Your data lives in two tables, but your question needs both. A JOIN lines them up, and the four kinds (INNER, LEFT, RIGHT, FULL) differ…
databases/why-databases-split-your-data-into-two-tables-and-link-them-by-id.md
Why databases split your data into two tables (and link them by id)
A database table looks like a spreadsheet: columns for each kind of information, one row per thing. But it comes with rules. Every column…