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…
//
Tag: MySQL
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…
Programming
Query the Database With Laravel Eloquent
Eloquent maps each table to a model class, so you read and write rows by calling methods instead of writing SQL. This tutorial covers…
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…
Programming
Paginate MySQL Results With PHP PDO
Splitting a long result set across pages comes down to turning a page number into a LIMIT and an OFFSET. This tutorial counts the…