Scribd
Upload
3 views6 pages

MySQL Data Types Explained

The document discusses various data types in MySQL, including TINYINT, SMALLINT, INT, BIGINT, FLOAT, DOUBLE, and DECIMAL. Each type is defined with its range and precision, highlighting their specific uses in database systems. Additionally, MEDIUMINT is mentioned as a type specific to MySQL and MariaDB.

Uploaded by

mohammed.farhan.ashraf
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
3 views6 pages

MySQL Data Types Explained

The document discusses various data types in MySQL, including TINYINT, SMALLINT, INT, BIGINT, FLOAT, DOUBLE, and DECIMAL. Each type is defined with its range and precision, highlighting their specific uses in database systems. Additionally, MEDIUMINT is mentioned as a type specific to MySQL and MariaDB.

Uploaded by

mohammed.farhan.ashraf
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd

Good Morning To

All Present here

By: Afrah and Hafeera


Today Data types in MySQL

we will Number datatype


cover
the topic
TINYINT : Stores very small whole numbers within a limited
range (e.g., -128 to 127 in Java).

SMALLINT or short: Stores a slightly larger range of whole


numbers.

INT or integer: The most common type for general-purpose


whole numbers, typically a 32-bit integer.

BIGINT or long: Used for very large whole numbers


when INT is insuffi cient, typically a 64-bit integer.

FLOAT: A single-precision, 32-bit floating-point number


(approx. 6-9 digits of precision).

DOUBLE or double precision: A double-precision, 64-bit


floating-point number, offering greater accuracy and a wider
range than FLOAT (approx. 15-17 digits of precision).
DECIMAL : This type stores an exact value and
allows the user to specify the required precision and
scale (number of digits before and after the decimal
point). It avoids the potential approximation errors
associated with FLOAT and DOUBLE.
Statistical Classification

MEDIUMINT is an integer data type specific to


database systems like MySQL and MariaDB.

You might also like