2.05 Data Types

0.0(0)
studied byStudied by 0 people
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
Card Sorting

1/8

encourage image

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