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

eCommerce Database modification

Challenge Task 1 of 3 We have an eCommerce database and it has a products table. It has the columns id, name, description and price.

Add a new product to the products table. Use any valid values you want. All columns are required. The id column is auto incrementing.

Type in your command below, then press Ctrl-Enter.

Bummer: Was expecting 4 entries in the products table. There's only 3.

INSERT INTO products(id, name, description, price) VALUE(NULL, "coat", "mink", 199.99);

2 Answers

54,331 Points

It should be VALUES instead of VALUE

I changed 199.99 to 200 and it went through. Weird.