2.05 Data Types
0.0(0)
Studied by 0 people
Learn
Practice Test
Spaced Repetition
Match
FlashcardsCard Sorting
1/8
There's no tags or description
Looks like no tags are added yet.
Study Analytics
Name | Mastery | Learn | Test | Matching | Spaced |
|---|
No study sessions yet.
9 Terms
1
New cards
data type
is a named set of values from which column values are drawn.
2
New cards
INT
positive and negative integer values.
3
New cards
VARCHAR(N)
values with 0 to N characters.
4
New cards
CHAR(N)
fixed string value, if string is less than stated, space padding will be added.
5
New cards
DATE
YYYY-MM-DD
6
New cards
TIME
hh:mm:ss
7
New cards
DATETIME
YYYY-MM-DD HH:MM:SS
8
New cards
DECIMAL(N,D)
numeric values with total N digits, of which D digits follow the decimal point
9
New cards
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
Note 
Flashcards (29)