Common MySQL data types.

Question 1

Category: Character
Storage: Length of characters + 2 bytes

Notes: Variable-length string with a maximum of 65,535 characters.

Answer 1

Data Type: TEXT

Example: ‘string’

Question 2

Category: Character
Storage: Length of characters + 1 byte

Notes: Variable-length string with a maximum of N characters; 0 ≤ N ≤ 65,535

Answer 2

Data Type: VARCHAR(N)

Example: ‘string’

Question 3

Category: Character
Storage: N bytes

Notes: Fixed-length string of length N; 0 ≤ N ≤ 255

Answer 3

Data Type: CHAR(N)

Example: ‘string’

Question 4

Category: Date and time
Storage: 5 bytes

Notes: Format: YYYY-MM-DD hh:mm:ss; Range: ‘1000-01-01 00:00:00’ to ‘9999-12-31 23:59:59’

Answer 4

Data Type: DATETIME

Example: ‘1776-07-04 13:45:22’

Question 5

Category: Date and time
Storage: 3 bytes

Notes: Format: hh:mm:ss

Answer 5

Data Type: TIME

Example: ‘1776-07-04 13:45:22’

Question 6

Category: Date and time
Storage: 3 bytes

Notes: Format: YYYY-MM-DD; Range: ‘1000-01-01’ to ‘9999-12-31’

Answer 6

Data Type: DATE

Example: ‘1776-07-04 13:45:22’

Question 7

Category: Decimal
Storage: 8 bytes

Notes: Approximate decimal numbers with range: -1.8E+308 to 1.8E+308

Answer 7

Data Type: DOUBLE

Example: 123.4 and -54.29685

Question 8

Category: Decimal
Storage: 4 bytes

Notes: Approximate decimal numbers with range: -3.4E+38 to 3.4E+38

Answer 8

Data Type: FLOAT

Example: 123.4 and -54.29685

Question 9

Category: Decimal
Storage: Varies depending on M and D

Notes: Exact decimal number where M = number of significant digits, D = number of digits after the decimal point

Answer 9

Data Type: DECIMAL(M,D)

Example: 123.4 and -54.29685

Question 10

Category: Integer
Storage: 8 bytes

Notes:
Signed range: -2^63 to 2^63 -1;

Unsigned range: 0 to 2^64 -1

Answer 10

Data Type: BIGINT

Example: 34 and -739448

Question 11

Category: Integer
Storage: 4 bytes

Notes:
Signed range: -2,147,483,648 to 2,147,483,647;

Unsigned range: 0 to 4,294,967,295

Answer 11

Data Type: INTEGER or INT

Example: 34 and -739448

Question 12

Category: Integer
Storage: 3 bytes

Notes: Signed range: -8,388,608 to 8,388,607; Unsigned range: 0 to 16,777,215

Answer 12

Data Type: MEDIUMINT

Example: 34 and -739448

Question 13

Category: Integer
Storage: 2 bytes

Notes:
Signed range: -32,768 to 32,767;

Unsigned range: 0 to 65,535

Answer 13

Data Type: SMALLINT

Example: 34 and -739448

Question 14

Category: Character
Storage: Length of characters + 2 bytes

Notes:
Variable-length string with a maximum of 65,535 characters.

Answer 14

Data Type: TEXT

Example: ‘string’