Essential MySQL Cheat Sheet by guslong
MySQL Data Types
Integers (marked x) that are "UNSIGNED" have the same range of values but start from 0 (i.e., an UNSIGNED TINYINT can have any value from 0 to 255).
Creating and modifying
SELECT * FROM tbl1 INNER JOIN tbl2 ON tbl1.id = tbl2.id;
String functions mySQL
MySQL calculation functions
Create table with auto-incrementing primary key