Seven DCI Apprentice673 Points
INSERT INTO with NULL
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.
Ive already re-watched the video many times, I seem to be perplex by this question, is auto incrementing usually involve NULL? I will attached again in the AM when my mind is fresh..
Steven Parker182,288 Points
You're quite right, the value for the auto-incrementing column can be NULL. You can also omit setting them entirely.
For a more specific answer, show the code line you were entering.
Isabelle Caspersson5,993 Points
I don't understand either. I wrote:
INSERT INTO products VALUES (NULL, isabelle, gul, 19);
I got the message: "Bummer: Was expecting 4 entries in the products table. There's only 3."