Understanding MySQL Data Types

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
);