Home >> FAQs/Tutorials >> MySQL Tutorials
MySQL Tutorial - Numeric Data Types
(Continued from previous topic...)
What Are Numeric Data Types?
MySQL supports the following numeric data types:
- BIT(n) - An integer with n bits.
- BOOL same as BOOLEAN - Boolean values stored in 1 bit.
- TINYINT - A small integer stored in 1 byte.
- SMALLINT - A small integer stored in 2 bytes.
- MEDIUMINT - A medium integer stored in 3 bytes.
- INT same as INTEGER - An integer stored in 4 bytes.
- BIGINT - An integer stored in 8 bytes.
- FLOAT - A single-precision floating-point number stored in 4 bytes.
- DOUBLE same as DOUBLE PRECISION - A double-precision floating-point number stored in 8 bytes.
- REAL - Same DOUBLE by default.
- DECIMAL(m,d) - A fixed-point number with m as the precision (total number of digits)
and d as the scale (number of digits after the decimal point).
(Continued on next topic...)
- What Is SQL Standard?
- How Many Groups of Data Types?
- What Are Character String Data Types?
- What Are the Differences between CHAR and NCHAR?
- What Are the Differences between CHAR and VARCHAR?
- What Are the Differences between BINARY and VARBINARY?
- What Are Numeric Data Types?
- What Are Date and Time Data Types?
- How To Calculate Expressions with SELECT Statements?
- How To Include Comments in SQL Statements?
- How To Include Character Strings in SQL statements?
- How To Escape Special Characters in SQL statements?
- How To Concatenate Two Character Strings?
- How To Include Numeric Values in SQL statements?
- How To Enter Characters as HEX Numbers?
- How To Enter Numeric Values as HEX Numbers?
- How To Enter Binary Numbers in SQL Statements?
- How To Enter Boolean Values in SQL Statements?
- What Are NULL Values?
- What Happens If NULL Values Are Involved in Expressions?
- How To Convert Numeric Values to Character Strings?
- How To Convert Character Strings to Numeric Values?
- How To Use IN Conditions?
- How To Use LIKE Conditions?
- How To Use Regular Expression in Pattern Match Conditions?
- How To Use CASE Expression?