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…
//
Tag: MySQL
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…
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…