Earlon Perry4,304 Points
Need help with Adding Data with SQL objectives. I can not get the objectives right.
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.
This is the answer i posted.
INSERT INTO products (id, name, description, price) VALUES (NULL, “DOVE”, “DEODORANT”, “3.99”);
Steven Parker177,843 Points
It looks like you're using word-processing type ("curly") quotes instead of normal programming quotes. Here it is with the quotes changed (and I just left them off the price):
INSERT INTO products (id, name, description, price) VALUES (NULL, "DOVE", "DEODORANT", 3.99);