Server Administration
Enable Gzip Compression in Apache
Enable gzip compression in Apache with mod_deflate and every text response shrinks before it crosses the wire. This tutorial loads the module, sets AddOutputFilterByType…
//
Author: admin
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…
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…