02-01 - variables

download / install

01

These are the basic variables in SQL

INT

M are the digits before the decimal, N are the digits after the decimal

DECIMAL(M,N)

02

VARCHAR(1)

VARCHAR are for strings, the length goes inside of the ()

03

BLOB are for binary files like pdfs, images, and audio

BLOB

04

DATE

format for DATE is YYYY-MM-DD

TIMESTAMP

format for TIMESTAMP is YYYY-MM-DD HH:MM:SS