Create a product classification table

Product classification table

Product classification is actually very simple, not much different from infinite classification. We first create a table .

id: category id.

catename: category name.

pid:parent class id.referred to as superior id.

Let’s first build the structure of the table, and then we will start the formal explanation.