MySQL Data Types

MySQL Data Types

MySQL Data Types

To Defining the fields in a table of database is important to the overall optimization.MySQL Data Types Uses many datatypes.These are following:

  • Numeric Data Types:
  1. INT
  2. TINYINT
  3. SMALLINT
  4. MEDIUMINT
  5. BIGINT
  6. FLOAT
  7. DOUBLE
  8. DECIMAL
  • Date and Time Types
  1. DATE
  2. DATETIME
  3. TIMETAMP
  4. TIME
  5. YEAR
  • String Types
  1. CHAR
  2. VARCHAR
  3. BLOB OR TEXT
  4. TINYBLOB OR TINYTEXT
  5. MEDIUMBLOB OR MEDIUMTEXT
  6. LONGBLUB OR LONGTEXT
  7. ENUM
Staff
Administrator-training-training-technist
Vivek Agarwal
Read More





Skip to toolbar
  • USA : +1-(917) 328-1140
  • UK : +44-(773) 940-0806
  • INDIA : +91-(779) 205-1814
  • KUWAIT : +965-(514) 31-431
  • DUBAI : +971-(557) 964-969
  • MALAYSIA : +91-(779) 205-1814
  • AUSTRAILIA : +91-(779) 205-1814