Numeric data types can hold integers, which include positive and negative whole numbers. Numeric data types can also contain fixed-point and floating-point numbers, which store fractions of whole numbers. This section walks you through the different numeric data types in MySQL. This section also shows you where Oracle, PostgreSQL, and SQL Server numeric data types are different.
Understanding numeric data types
Numeric data types in MySQL
The numeric data types in MySQL include the following:
- INT: An INT value can range from -2147483648 to 2147483647. An INT can only store whole numbers. It can't store numbers with decimal places. Any value you try to place with decimal places will be rounded up or down depending on...