1. Numeric Data Types

Store numbers.

  • Examples: INTEGER, FLOAT, DECIMAL
  • Use Cases: Counting items, financial calculations

2. String Data Types

Store sequences of characters (text).

  • Examples: CHAR, VARCHAR, TEXT
  • Use Cases: Names, addresses, descriptions

3. Date and Time Data Types

Store dates and times.

  • Examples: DATE, TIME, DATETIME, TIMESTAMP
  • Use Cases: Event logging, scheduling

4. Boolean Data Type

Store true/false values.

  • Examples: BOOLEAN, BIT
  • Use Cases: Flags, status indicators

5. Binary Data Types

Store binary data like files or images.

  • Examples: BINARY, VARBINARY, BLOB
  • Use Cases: Storing images, documents

6. Spatial Data Types

Store geometric or geographic data.

  • Examples: POINT, LINESTRING, POLYGON
  • Use Cases: GIS data, mapping

7. XML and JSON Data Types

Store structured data in XML or JSON format.

  • Examples: XML, JSON
  • Use Cases: Document storage, APIs

8. Enumerated Data Types

Store one of several predefined values.

  • Examples: ENUM
  • Use Cases: Fixed categories like status codes

9. Composite Data Types

Store complex types or a combination of other data types.

  • Examples: ARRAY, ROW
  • Use Cases: Multi-valued attributes, complex records