Groups of Data Types in MySQL

Q

How Many Groups of Data Types in MySQL?

✍: 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.

 

Introduction to SQL Basics in MySQL

⇒⇒MySQL Database Tutorials

2016-10-16, 175👍, 0💬