Getting Started with SQL and Relational Databases/

...

/

Insert Product Data

Insert Product Data

Revise the insert command to store data in the products table.

We'll cover the following...

Insert data

Now that the table is ready, let’s insert a new product:

MySQL
insert into products(name, price) values ('Game of Thrones-S01-DVD', 50.0);

In the insert statement above, we first specify the columns we’ll give values for. Then, we provide the values themselves and get a Succeeded response because there’s nothing to display.

Let’s double-check that the product has been created:

MySQL
select * from products;

When we run the code above, we get the following output:

+----+-----------------------------+-------+
| id | name                        | price |
+----+-----------------------------+------
...