How Many Groups of Data Types

Q

How Many Groups of Data Types? - MySQL FAQs - Introduction to SQL Basics

✍: FYIcenter.com

A

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.

2007-05-11, 4629👍, 0💬