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…
//
Category: Database Administration
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…
Database Administration
Restore MySQL backup from the terminal
Efficiently import MySql backup database records from an .sql file using the mysql command from the terminal. A quick and direct approach to restore…
Database Administration
Grant Privileges to MySQL User
Assign privileges and roles to MySQL user accounts and roles using MySQL GRANT statement. This is to be able for a MySQL user to…
Database Administration
Create MySQL Database User
Create a MySQL user with password to access a MySQL database from a specific host to do things like adding, updating, deleting, and listing…