Latest snippets

Return 0 if field is NULL in MySQL

Use IF statement in MySQL

Convert INT to DATETIME in MySQL

Select year from a Unix timestamp in MySQL

Convert Unix timestamp to human readable date in MySQL

Group by year of Unix timestamp in MySQL

Get current date in MySQL

Get current year in MySQL

Extract year from a date in MySQL

Count total rows by year in MySQL

Import an SQL file using the command line in MySQL

Backup MySQL database

Backup MySQL schema only

Backup only selected tables in MySQL

Skip tables in MySQL backup

Backup MySQL data only

Backup MySQL database without locking tables

Create INSERT statement for each record with mysqldump

Backup only certain rows from MySQL database

Delete records from MySQL table