MySQL Numeric Data types

Overview

In this tutorial, we will learn MySQL Numeric Data types. MySQL supports many data types to store numeric data like
integer data types, floating-point types, fixed-point types, etc.

Integer Data Types

The integer data type is used for storing whole numbers.
Whole numbers do not have decimal digits. For example, 25 is a whole number and 32.7 is not a whole number.

The following is the list of numeric data types:

Integer Data type	Description
TINYINT	Used for very small integer
SMALLINT	Used for small integer
MEDIUMINT	Used for medium-sized integer
INTEGER	Used for normal integer
BIGINT	Used for large integer

Floating-Point Data Types

The floating-point data types are used to represent approximate-value numbers that have an integer part, a fractional part, or both. The floating-point data types are:

FLOAT – Single-precision floating-point number
DOUBLE – Double-precision) floating-point number

These types represent values in the native binary floating-point format (IEEE 754).

Syntax

The FLOAT data type is assigned using the syntax:

FLOAT (N, D)

N is the maximum number of decimal digits and D is the number of digits following the decimal point. A single-precision floating-point integer is accurate to approximately 7 decimal places.

The DOUBLE data type is assigned using the syntax:

DOUBLE (N, D)

N is the maximum number of decimal digits and D is the number of digits following the decimal point. A double-precision floating-point integer is accurate to approximately 15 decimal places.

Fixed-Point Data Types

The fixed-point data type in MySQL is DECIMAL. DECIMAL data type is used to represent exact-value numbers that have an integer part, a fractional part, or both.

All values of the DECIMAL column have the same number of decimal places and are stored exactly as specified.

The DECIMAL data type is assigned using the syntax:

DECIMAL (N, D)

N is the maximum number of significant digits that can be stored and D is the number of digits following the decimal point (from 1 to 255).

—