SQL Data Types

Data Types

[[SQL Data Manipulation]]

Numerical - Basic

  • INT for integers
  • BIGINT for bigger integers
  • FLOAT for floating points numbers.
  • DOUBLE for bigger floating point numbers.

Strings - Basic

  • CHAR - fixed length string
  • VARCHAR - variable length string
  • TEXT - for text with max 65k bytes
  • BLOB - for Binary Large OBjects

Date

  • DATE
  • DATETIME
  • TIME
  • TIMESTAMP