# Numeric Types : Introduction « Data Types « MySQL Tutorial

Home
MySQL Tutorial
 1 Introduction 2 Select Query 3 Database 4 Table 5 Table Join 6 Subquery 7 Insert Update Delete 8 Logic Operator 9 View 10 Data Types 11 Procedure Function 12 Cursor 13 Trigger 14 Date Time Functions 15 Comparison Functions Operators 16 Aggregate Functions 17 Cast Functions Operators 18 Control Flow Functions 19 Encryption Compression Functions 20 Information Functions 21 Math Numeric Functions 22 Miscellaneous Functions 23 String Functions 24 Regular Expressions 25 Data Dictionary 26 MySQL Utilities 27 Privilege
 MySQL Tutorial » Data Types » Introduction
10.16.4.Numeric Types
 Type Name Value Range Unsigned TINYINT -128 to 127 0-255 SMALLINT -32768 to 32767 0-65535 MEDIUMINT -8388608 to 8388607 0-16777215 INT -2147483648 to 2147483647 0-4294967295 BIGINT -9223372036854775808 - 9223372036854775807 0-18446744073709551615 FLOAT(M,D) Varies depending on values Varies depending on values DOUBLE(M,D) Varies depending on values Varies depending on values DECIMAL(M,D) Varies depending on values Varies depending on values

If the column is numeric and declared UNSIGNED, the range doubles for the given type.

FLOATs, DOUBLEs, and DECIMALs can hold fractions.

The other types cannot.

The first number is the number of digits for the whole number and the second is the number of digits for the fraction.

You can limit the number of digits to the right of the decimal point.

For 5.6876, FLOAT(4,2) type column would store 5.69.

FLOAT(4,3) would be store 5.688.

MySQL rounds the decimal to fit the number of digits right of the decimal point.

 10.16.Introduction 10.16.1. The basic datatypes 10.16.2. Date Datatypes 10.16.3. Numeric Types Storage 10.16.4. Numeric Types 10.16.5. ZEROFILL,UNSIGNED,SERIAL,SERIAL DEFAULT VALUE 10.16.6. Using Data Types from Other Database Engines 10.16.7. Data type mapping occurs at table creation time, after which the original type specifications are discarded. 10.16.8. Storage Requirements for Numeric Types 10.16.9. Storage Requirements for Date and Time Types 10.16.10. The format of the zero value for each type.