Programming
Create a Database Migration in Laravel
A migration defines a table in PHP instead of hand-written SQL, and keeps that definition versioned alongside your code. This tutorial generates one with…
//
Tag: MySQL
Database Administration
Reset the MySQL root Password From the Terminal
Reset the MySQL root password from the terminal when you are locked out, using skip-grant-tables recovery mode and ALTER USER to set a new…
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…
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…