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

juannie jimenez
juannie jimenez
2,375 Points

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
PRO
KRIS NIKOLAISEN
Pro Student 51,000 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