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: Command Line
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…
Server Administration
Connect to a Remote Server Using SSH Keys
Log in to a remote server without a password using SSH keys. Generate an ed25519 key pair, copy the public key to the server,…
Server Administration
Schedule Tasks With Cron
Run commands on a fixed timetable with cron. This tutorial opens your crontab, explains the five time fields, schedules a nightly logged backup, and…