What are the numeric data types in MySQL?

MySQL has exact integer types, the exact fixed-point type DECIMAL, and the approximate floating-point types FLOAT and DOUBLE.

Integer types, with their signed ranges:

• TINYINT: 1 byte, from -128 to 127
• SMALLINT: 2 bytes, from -32,768 to 32,767
• MEDIUMINT: 3 bytes, from -8,388,608 to 8,388,607
• INT: 4 bytes, from -2,147,483,648 to 2,147,483,647
• BIGINT: 8 bytes, from -2^63 to 2^63 - 1

UNSIGNED allows only nonnegative values, so an INT UNSIGNED column holds 0 to 4,294,967,295.

Decimal and floating-point types:

• DECIMAL, also called NUMERIC, stores exact values, for financial data.
• FLOAT uses 4 bytes for single precision, and DOUBLE uses 8 bytes for double precision, so DOUBLE is more precise. Both are approximate, so exact comparisons can fail.

CREATE TABLE products (
    id INT AUTO_INCREMENT PRIMARY KEY,
    price DECIMAL(10,2),
    weight FLOAT,
    quantity SMALLINT UNSIGNED
);