Category Archives: MySQL

mysql

January 3, 2026Cheat Sheet, MySQLRoman

Backup

mysqldump -u root dbname > backup.sql

Restore

mysql -u root dbname < backup.sql

Commands

# Create database
CREATE DATABASE dbname;

# Create user
CREATE USER 'user'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON dbname.* TO 'user'@'localhost';

# Create database
CREATE DATABASE dbname;

# Create user
CREATE USER 'user'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON dbname.* TO 'user'@'localhost';

MSSQL’s ISNULL in MySQL

March 11, 2012MySQLRoman

I am unable to remember this and have to find it each time I need it. In MSSQL there is a great function called ISNULL. It has two parameters. If the first one is NULL it takes the second one. In MySQL ISNULL takes only one parameter and checks whether it is NULL or not. The real replacement for MSSQL‘s ISNULL in MySQL is IFNULL.