Numeric Types : Introduction « Data Types « MySQL Tutorial






  1. MySQL Tutorial
  2. Data Types
  3. Introduction
Type NameValue RangeUnsigned
TINYINT-128 to 1270-255
SMALLINT-32768 to 327670-65535
MEDIUMINT-8388608 to 83886070-16777215
INT-2147483648 to 21474836470-4294967295
BIGINT-9223372036854775808 - 92233720368547758070-18446744073709551615
FLOAT(M,D)Varies depending on valuesVaries depending on values
DOUBLE(M,D)Varies depending on valuesVaries depending on values
DECIMAL(M,D)Varies depending on valuesVaries 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.