Mysql Cheat Sheet

Explore key concepts, syntax, and usage examples for Mysql — perfect for quick reference.

Resource
Online Related
Data Types
Types
  • CHAR
    💡 String (0 - 255)
  • VARCHAR
    💡 String (0 - 255)
  • TINYTEXT
    💡 String (0 - 255)
  • TEXT
    💡 String (0 - 65535)
  • BLOB
    💡 String (0 - 65535)
  • MEDIUMTEXT
    💡 String (0 - 16777215)
  • MEDIUMBLOB
    💡 String (0 - 16777215)
  • LONGTEXT
    💡 String (0 - 429496-7295)
  • LONGBLOB
    💡 String (0 - 429496-7295)
  • TINYINT x
    💡 Integer (-128 to 127)
  • SMALLINT x
    💡 Integer (-32768 to 32767)
  • MEDIUMINT x
    💡 Integer (-8388608 to 8388607)
  • INT x
    💡 Integer (-2147-483648 to 214748-3647)
  • BIGINT x
    💡 Integer (-9223-372-036-854-775808 to 922337-203-685-477-5807)
  • FLOAT
    💡 Decimal (precise to 23 digits)
  • DOUBLE
    💡 Decimal (24 to 53 digits)
  • DECIMAL
    💡 "-DOU-BLE-" stored as string
  • DATE
    💡 YYYY-MM-DD
  • DATETIME
    💡 YYYY-MM-DD HH:MM:SS
  • TIMESTAMP
    💡 YYYYMM-DDH-HMMSS
  • TIME
    💡 HH:MM:SS
  • ENUM
    💡 One of preset options
  • SET
    💡 Selection of preset options
Operators
Assignment Operators Logical Operators Comparison Operators
String
String Comparison Regular Expressions String Functions
Numeric
Arithmetic Operators Mathematical Functions
Date
Date and Time
Group
GROUP BY Functions
Information
Information Functions
Encrypt
Encryption and Compression
Miscellaneous
Miscellaneous Functions
Samples
Select Queires
  • Returns all columns
    💡 SELECT * FROM table
  • Returns all columns
    💡 SELECT * FROM table1, table2, ...
  • Returns specific column
    💡 SELECT field1, field2, ... FROM table1, table2, ...
  • Returns rows that match condition
    💡 SELECT ... FROM ... WHERE condition
  • Returns with orders
    💡 SELECT ... FROM ... WHERE condition GROUP BY field
  • Returns withd orders and match condition
    💡 SELECT ... FROM ... WHERE condition GROUP BY field HAVING condition2
  • Returns first 10 rows
    💡 SELECT ... FROM ... WHERE condition LIMIT 10
  • Returns with no repeats
    💡 SELECT DISTINCT field1 FROM ...
  • Returns and joind
    💡 SELECT ... FROM t1 JOIN t2 ON t1.id1 = t2.id2 WHERE condition