MySQL Basics Practice Test: MySQL Data Type Reference, Operators and Functions — Flashcards

Quiz questions on numeric, string and spatial data types, operators and functions.

MySQL has three main data types: numeric, date and time, and string.

Other data types include:
Spatial: Geometric-based information for geographic data
JSON: Stores JSON documents
ENUM: A string object whose value is chosen from a list of permitted values defined at the time of column creation 

MySQL also has arithmetic operators, which are used to perform mathematical calculations on numerical values in queries. These include:
Addition (+)
Subtraction (-)
Multiplication (*)
Division (/: )
Modulus (%) 

MySQL also has logical operators, which are used to join numerous conditions in a WHERE clause to filter data from a table. MySQL's three logical operators are AND, OR, and NOT. 

Here are some examples of data types in MySQL:
TINYINT(size): Allows signed integers from -128 to 127 and unsigned integers from 0 to 255
SMALLINT(size): Allows signed integers from -32768 to 32767 and unsigned integers from 0 to 65535
CHAR(size): Holds up to 255 characters and allows a fixed length string
VARCHAR(size): Holds up to 255 characters and allows a variable length string