Category: SQL

Give and remove privileges with GRANT and REVOKE.

Back up databases regularly and practice restores.

Move data with dumps, CSV imports, and export tools.

Query MySQL safely from PHP using PDO prepared statements.

Use Laravel’s query builder/Eloquent with bound parameters.

Use CodeIgniter’s query builder / bound queries for MySQL access.

Model parents with many children via a foreign key on the child.

Resolve M:N with a junction table of two foreign keys.

Keep relationships valid so child rows cannot orphan parent keys.

Configure ON DELETE / ON UPDATE actions on foreign keys.