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

How?

Can't figure this out:

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.

1 Answer

KRIS NIKOLAISEN
PRO
KRIS NIKOLAISEN
Pro Student 51,822 Points

You will use an INSERT INTO statement

INSERT INTO table_name (column1, column2, column3, ...)
VALUES (value1, value2, value3, ...);

note: you don't have to include ID since it is auto-incrementing