Databases Modifying Data with SQL Adding Data to a Database Adding Data With SQL

am i supposed to already know what the id is for practice question , adding new product to ecommerce ?

INSERT IN products (id, name, description, price) VALUES ("12", "Ocean", "Blue", "9.99") this is what i have as my answer but now its wrong. was correct the first time.

1 Answer

KRIS NIKOLAISEN
KRIS NIKOLAISEN
53,362 Points

According to the instructions the id column is auto incrementing so you can either enter it with a null value or leave it out altogether.

Also you will want to use INSERT INTO products instead of INSERT IN products

got it! thanks !