Code QuizAdvanced

Two Primary Keys in One Table

Spot why this CREATE TABLE fails when defining keys for an orders schema.

Codesql

CREATE TABLE order_items (
  order_id   INT PRIMARY KEY,
  product_id INT PRIMARY KEY,
  quantity   INT NOT NULL,
  price      DECIMAL(10,2) NOT NULL
);

What is the bug in this table definition?

Next →Foreign Keys and Indexing Basics