Common Types

  • INT – integers
  • VARCHAR – variable-length strings
  • DATE – date values
  • DECIMAL(10,2) – precise fixed-point numbers
CREATE TABLE product (
  id INT,
  name VARCHAR(100),
  price DECIMAL(10,2),
  created_at DATE
);