Show Menu
Cheatography
  1. Home >
  2. Cheat Sheets >

MySQL basics Cheat Sheet (DRAFT) by

Cheat sheet handout for an introductory course to MySQL

This is a draft cheat sheet. It is a work in progress and is not finished yet.

Functions

Functions and Modifiers
for Use with GROUP BY
AVG
BIT_AND
BIT_OR
BIT_XOR
COUNT
COUNT DISTINCT
GROUP_CONCAT
MAX
MIN
STD
STDDEV
STDDEV_POP
STDDEV_SAMP
SUM
VARIANCE
VAR_POP
VAR_SAMP

Numeric functions
%
*
+
-
/
ABS
ACOS
ASIN
ATAN
ATAN2
CEIL
CEILING
CONV
COS
COT
CRC32
DEGREES
DIV
EXP
FLOOR
LN
LOG
LOG10
LOG2
MOD
PI
POW
POWER
RADIANS
RAND
ROUND
SIGN
SIN
SQRT
TAN
TRUNCATE
 

DATA TYPES

CHAR
String, length 0 - 255
VARCHAR
String, length 0 - 255
TINYTEXT
String, length 0 - 255