Data types in MySQL

Numeric Type

Field	Storage Bytes	Min Signed	Max Signed	Max UnSigned
Tnyint	1	-128	127	255
Smallint	2	-32768	32767	65535
Mediumint	3	-8388608	8388607	16777215
Int	4	-2147483648	2147483647	4294967295
Bigint	8	-2⁶³	2⁶³	2⁶⁴

Decimal( Precission, Scale )

Precission : Number of Significant digits
Scale : Number digits after decimal point.

Example : Price DECIMAL(5,3)

Here Maximum Price ( value ) we can store is -99.999 to 99.999
Decimal is used where exact and accurate value is to be stored like monetary values.

FLOAT ( M,D)

M : Digits in total
D : Digits after decimal

Example : average_value FLOAT(4,2)

Here we can insert data in range of -99.99 to 99.99
Float is 32 bit single precision.

DOUBLE (M, D)

M : Digits in total
D : Digits after decimal

Example : value FLOAT(5,2)

Here we can insert data in range of -999.99 to 999.99
Double is 64 bit double precision.

REAL (M, D)

M : Digits in total
D : Digits after decimal

Example : value REAL(5,2)

Here we can insert data in range of -999.99 to 999.99

This article is written by plus2net.com team.

plus2net.com

More on Alter or coy table , add update or delete records in SQL

Adding records to a table by insert command
Adding records with set option
Changing structure of the table by alter query
Create table query with if exists sql with php script
Creating a new table by using data from one table
Change the name of a table
Copying data from one table to another table
Delete records from a table with conditions
Delete table by using DROP sql
Update SQL commands
Inserting SUM, AVG data from one table column to other using group by command
Listing all tables and Database present in MySQL
Table Records are downloaded as .csv file

Queries INSERT UPDATE

Aggregate Queries AVG ( Average ) SUM MIN MAX

SQL Video Tutorials