Database Administration
Add a Column to a MySQL Table With ALTER TABLE
Add a column to a MySQL table with ALTER TABLE - no drop, no re-import, the data stays put while the schema changes. This…
//
Category: Database Administration
Database Administration
Import a CSV Into MySQL With LOAD DATA INFILE
Import a CSV into MySQL with LOAD DATA INFILE, the server's bulk loader. This tutorial maps a comma-separated file onto a table in one…
Database Administration
Group and Aggregate Rows With GROUP BY in MySQL
Use GROUP BY in MySQL to collapse rows that share a value into one summary row each, with COUNT, SUM, AVG and MAX computing…
Database Administration
Create a View in MySQL
A view stores a SELECT under a name, so you can query it like a table while the data stays live in the base…
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…