Database Administration
Create an Index and Read EXPLAIN in MySQL
Create an index in MySQL and use EXPLAIN to prove it worked, turning a 5,000-row full table scan into a targeted lookup of just…
//
Tag: SQL
Database Administration
Add a Foreign Key in MySQL
Add a foreign key in MySQL to link two tables and have the database enforce it, rejecting orphan rows while an ON DELETE CASCADE…
Database Administration
Create a MySQL Table From the Terminal
Create a MySQL table from the terminal with a single CREATE TABLE statement: typed columns, an AUTO_INCREMENT primary key, and sensible defaults, confirmed with…
Database Administration
Join Tables in MySQL
Join tables in MySQL to combine related rows in a single query. Learn INNER JOIN for matches, LEFT JOIN to keep unmatched rows, table…