-Basically, DataType is specify the type of the attribute of the table like integer,float, Boolean etc.
Numeric Data type:
INT: it stored integer number which are signed(-2147483648 to 2147483647) or unsigned.
TINYINT: It is very small integer data type which are stored very small number in the range of -128 to 127.
SMALLINT: range -32768 to 32767
MEDIUMINT: range -8388608 to 8388607
BIGINT: range -9223372036854775808 to 9223372036854775807
FLOAT: used to store the floating number
DOUBLE: It store long float.
DECIMAL: Used to store the decimal numbers.
String Data type:
CHAR: Maximum size of 255 characters. used to store fixed length string.
VARCHAR: Maximum size of 255 characters. used to store variable length string.
TEXT: Maximum size of 65,535 characters.
TINYTEXT: Maximum size of 255 characters.
MEDIUMTEXT: Maximum size of 16,777,215 characters.
LONGTEXT: Maximum size of 4GB or 4,294,967,295 characters.
Date and time Data type:
DATE: range from '1000-01-01' to '9999-12-31'
DATETIME: range from'1000-01-01 00:00:00' to '9999-12-31 23:59:59'
TIMESTAMP: range from '1970-01-01 00:00:01' UTC to '2038-01-19 03:14:07' TC.
TIME: range from '-838:59:59' to '838:59:59'.
YEAR: Year value as 2 digits or 4 digits.(default is 4 digit)