MySQL Data Types

MySQL Data Types

      MySQL  Data Types are used to store specific kind of data in the DataBase

 for ex: telephone number should be Numberic

            Name should be alphabets

            Date of Birth will be in Date Time Format etc.,

1)TINYINT

2)SMALLINT

3)MEDIUMINT

4)INT

5)BIGINT

6)FLOAT

7)DOUBLE

8)DECIMAL

9)BIT

10)CHAR

11)VARCHAR

12)TINYBLOB

13)TINYTEXT

14)BLOB

15)TEXT

16)MEDIUMBLOG

17)MEDIUMTEXT

18)LONGBLOB

19)LONGTEXT

20)ENUM

21)SET

22)DATE

23)TIME

24)DATETIME

25)YEAR

26)TIMESTAMP

Tags:  MYSQL Data Types,MySQL Datatypes, Data Types in MySQL, DataTypes in Mysql,MYSQL Date Datatypes, MySQL char DataTypes, MySQL Numeric Data Types