MySQL Basics Practice Test: Data Types — Flashcards

Quiz on data value categories, datatypes, sequences and type conversions.

MySQL has three main data types: string, numeric, and date and time. MySQL also supports the following data types:
Numeric: Includes exact numeric data types like integer, decimal, and numeric, and approximate numeric data types like integer, decimal, and numeric. MySQL also has a BIT data type for storing bit values.
Date and time: Includes types for date and time, as well as the combination of date and time. MySQL also supports the timestamp data type for tracking changes in a row of a table.
Spatial: Includes data types that store geometry data. Most databases, including MySQL, automatically come with spatial data types.
JSON: A lightweight data interchange format widely used in web applications. The JSON type in MySQL is considered a text type, and it can store and retrieve large JSON texts.
VARCHAR: Used to store the characters or strings that can contain any alphabet, integers, or special symbols.
Binary: Supports two binary data types: BINARY and VARBINARY. BINARY is used to store fixed-length binary data, while VARBINARY is used to store variable-length binary data.
BLOB: Stores unprocessed binary data, typically files, that can be retrieved and manipulated like the other common datatypes.