I keep getting an error setting primary key

Question

I tried setting my primary key, purchase number using the alternative method but it keeps popping up an error, is there anything wrong with my code, please

CREATE TABLE sales
(
purchase_number INT NOT NULL auto_increment,
    date_of_purchase DATE NOT NULL,
    customer_id INT,
    item_code VARCHAR(10) NOT NULL
PRIMARY KEY (purchase_number)
);

Answer 1

Hi Ajayi!

Thanks for reaching out.

You've just missed the comma before designating the primary key. Please add it and retry running the query.

    item_code VARCHAR(10) NOT NULL,
PRIMARY KEY (purchase_number)

Hope this helps.
Best,
Martin

I keep getting an error setting primary key

Submit an answer

related questions