商品數(shù)據(jù)庫設(shè)計(jì)可以使用MySQL的ENUM類型來實(shí)現(xiàn)。以下是一個(gè)示例：

1. 創(chuàng)建一個(gè)名為products的表，包含以下字段：

CREATE TABLE products (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255) NOT NULL,
    description TEXT,
    price DECIMAL(10, 2) NOT NULL,
    category_id INT,
    FOREIGN KEY (category_id) REFERENCES categories(id)
);

1. 接下來，創(chuàng)建一個(gè)名為categories的表，包含以下字段：

CREATE TABLE categories (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255) NOT NULL
);

1. 我們可以插入一些示例數(shù)據(jù)：

INSERT INTO products (name, description, price, category_id) VALUES ('Product A', 'Description of Product A', 99.99, 1);
INSERT INTO products (name, description, price, category_id) VALUES ('Product B', 'Description of Product B', 49.99, 2);
INSERT INTO products (name, description, price, category_id) VALUES ('Product C', 'Description of Product C', 199.99, 3);
INSERT INTO products (name, description, price, category_id) VALUES ('Product D', 'Description of Product D', 79.99, 1);
INSERT INTO products (name, description, price, category_id) VALUES ('Product E', 'Description of Product E', 39.99, 2);

這樣，我們就創(chuàng)建了一個(gè)包含商品名稱、描述、價(jià)格和類別ID的商品數(shù)據(jù)庫表。