1/8
Looks like no tags are added yet.
Name | Mastery | Learn | Test | Matching | Spaced |
---|
No study sessions yet.
data type
is a named set of values from which column values are drawn.
INT
positive and negative integer values.
VARCHAR(N)
values with 0 to N characters.
CHAR(N)
fixed string value, if string is less than stated, space padding will be added.
DATE
YYYY-MM-DD
TIME
hh:mm:ss
DATETIME
YYYY-MM-DD HH:MM:SS
DECIMAL(N,D)
numeric values with total N digits, of which D digits follow the decimal point
integer
integer data types represent positive and negative integers
TINYINT 1 byte
SMALLINT 2 bytes
MEDIUMINT 3 bytes
INTEGER or INT 4 bytes
BIGINT 8 bytes