Getting Started with SQL and Relational Databases/

...

/

Create Table Products

Create Table Products

Learn to create a new table in our existing database.

We'll cover the following...

What we’ll learn

In the previous chapters, we started implementing our basic customer relationship management system. We already implemented the customers_db database and the customers table. In this chapter, we’re going to implement the products table.

Below are some features of the products table:

  • It will have a primary key id. This will be an integer, not null, and auto-incremented.
  • It will have a name, which is going to be a string, not null, and unique. It will have a price, which is going to be a
...