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 aprice, which is going to be a