MySQL support 3 groups of data types as listed below:
=> String Data Types - CHAR, NCHAR, VARCHAR, NVARCHAR, BINARY, VARBINARY, TINYBLOB, TINYTEXT,
BLOB, TEXT, MEDIUMBLOB, MEDIUMTEXT, LONGBLOB, LONGTEXT, ENUM, SET
=> Numeric Data Types - BIT, TINYINT, BOOLEAN, SMALLINT, MEDIUMINT, INTEGER, BIGINT, FLOAT,
DOUBLE, REAL, DECIMAL.
=> Date and Time Data Types - DATE, DATETIME, TIMESTAMP, TIME, YEAR.
=> String Data Types - CHAR, NCHAR, VARCHAR, NVARCHAR, BINARY, VARBINARY, TINYBLOB, TINYTEXT,
BLOB, TEXT, MEDIUMBLOB, MEDIUMTEXT, LONGBLOB, LONGTEXT, ENUM, SET
=> Numeric Data Types - BIT, TINYINT, BOOLEAN, SMALLINT, MEDIUMINT, INTEGER, BIGINT, FLOAT,
DOUBLE, REAL, DECIMAL.
=> Date and Time Data Types - DATE, DATETIME, TIMESTAMP, TIME, YEAR.
No comments:
Post a Comment