What type does mysql use to store numbers?

Mysql uses integer types, floating point number types, fixed point number types, unsigned integer types, etc. to store numbers. Detailed introduction: 1. Integer types include TINYINT, SMALLINT, MEDIUMINT, INT, and BIGINT; 2. Floating point types include FLOAT, DOUBLE, and DECIMAL; 3. Fixed-point types include NUMERIC and DEC; 4. Unsigned integer types include TINYINT UNSIGNED, SMALLINT UNSIGNED and so on.

#The operating environment of this article: Windows 10 system, MySQL 8 version, Dell G3 computer.

In MySQL, we can use a variety of data types to store numbers. Choosing the right data type is critical to the efficiency and accuracy of data storage. Here are some commonly used MySQL data types for storing numbers:

Integer Types (Integer Types):

TINYINT: Storage range is -128 to 127 small integer.

SMALLINT: Stores medium integers in the range -32768 to 32767.

MEDIUMINT: Stores medium integers in the range -8388608 to 8388607.

INT: Stores integers ranging from -2147483648 to 2147483647.

BIGINT: Stores large integers ranging from -9223372036854775808 to 9223372036854775807.

Floating-Point Types:

FLOAT: single-precision floating-point number, storage range is -3.402823466E 38 to -1.175494351E-38, 0 and floating point numbers from 1.175494351E-38 to 3.402823466E 38.

DOUBLE: Double precision floating point number, the storage range is -1.7976931348623157E 308 to -2.2250738585072014E-308, 0 and 2.2250738585072014E-308 to 1.7976931348623157E 308 floating point numbers.

DECIMAL: Exact decimal, the storage range and precision are defined by the user, suitable for storing currency or other numbers that require high-precision calculations.

Fixed-Point Types:

NUMERIC: Same as DECIMAL, the storage range and precision are defined by the user.

DEC: Same as DECIMAL, the storage range and precision are defined by the user.

Unsigned Integer Types:

TINYINT UNSIGNED: Stores unsigned small integers in the range 0 to 255.

SMALLINT UNSIGNED: Stores an unsigned medium integer in the range 0 to 65535.

MEDIUMINT UNSIGNED: Stores an unsigned medium integer in the range 0 to 16777215.

INT UNSIGNED: Stores an unsigned integer in the range 0 to 4294967295.

BIGINT UNSIGNED: Stores an unsigned big integer ranging from 0 to 18446744073709551615.

Based on the range and precision requirements of the numbers to be stored, we can choose the appropriate data type. If accuracy is important, such as when storing currency or calculating numbers that require high precision, the DECIMAL or NUMERIC types are better choices. If the number is an integer and has a small range, you can use the integer type. If the number is a floating point number, you can choose FLOAT or DOUBLE. The unsigned integer type is suitable for situations where non-negative numbers need to be stored.

In short, choosing the appropriate MySQL data type is very important for storing numbers, which can ensure data accuracy and storage efficiency.

The above is the detailed content of What type does mysql use to store numbers?. For more information, please follow other related articles on the PHP Chinese website!