Data Types – MySQL

MySQL Best Practices

MySQL supports different data types while creating columns i.e. what type of value is using for the column or fixed/variable length etc.

It has different types of data types i.e.

Numeric: TINYINT, SMALLINT, MEDIUMINT, INT, BIGINT, DECIMAL, FLOAT, DOUBLE, BIT

String: CHAR, VARCHAR, BINARY, VARBINARY, TINYBLOB, BLOB, MEDIUMBLOB, LONGBLOB, TINYTEXT, TEXT, MEDIUMTEXT, LONGTEXT, ENUM, SET

Date and Time: DATE, TIME, DATETIME, TIMESTAMP, YEAR

There are many more data type are there which MySQL use.

Leave a Reply

Your email address will not be published. Required fields are marked *