Welcome to plsql4all.blogspot.com SQL, MYSQL, ORACLE, TERADATA, MONGODB, MARIADB, GREENPLUM, DB2, POSTGRESQL.

Saturday, 23 August 2014

Data types in MySql

There are many data types in MySql. Some of them are listed below:-

1.       INT
2.       TINYINT 
3.       SMALLINT 
4.       MEDIUMINT 
5.       BIGINT 
6.       FLOAT(M,D) 
7.       DOUBLE(M,D)
8.       DECIMAL(M,D)
9.       DATE 
10.   DATETIME 
11.   TIMESTAMP
12.   TIME 
13.   YEAR(M)
14.   CHAR(M) 
15.   VARCHAR(M)

16.   BLOB or TEXT




Please provide your feedback in the comments section above. Please don't forget to follow.