Common Data Types

  • INT: Whole numbers
  • DECIMAL: Fixed-point precision numbers
  • VARCHAR(n): Variable-length strings
  • DATE / DATETIME: Date values

Example Table

CREATE TABLE orders (
  order_id INT,
  total_amount DECIMAL(10,2),
  order_date DATE
);