MySQL Cheat Sheet

mysql.sql

# Create database.
CREATE DATABASE some_database_name;

# Create a user with all the priviliges for the database.
GRANT ALL PRIVILEGES ON some_database_name.* TO some_user@'localhost' IDENTIFIED BY 'some_pass' WITH GRANT OPTION; 

# Make sure our changes will get used.
FLUSH PRIVILEGES;

# Sorting in descending order.
SELECT * FROM a ORDER BY a.a DESC

# Sorting in ascending order.
SELECT * FROM a ORDER BY a.a ASC