MySQLは注文システムのギフト管理機能を実装します

SELECT * FROM gift;

SELECT * FROM gift_type;

INSERT INTO gift (gift_id, gift_name, gift_amount, gift_description, gift_price)
VALUE (1, '礼品1', 10, '这是一件很不错的礼品', 100);

UPDATE gift SET gift_name='礼品1' WHERE gift_id=1;

DELETE FROM gift WHERE gift_id=1;

INSERT INTO gift_order (order_id, gift_id, gift_amount, gift_price)
VALUE (1, 1, 1, 100);

SELECT * FROM gift_order;

-- 创建赠品表 
CREATE TABLE gift (
  gift_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
  gift_name VARCHAR(100),
  gift_amount INT,
  gift_description VARCHAR(200),
  gift_price DECIMAL
);

-- 创建赠品类型 
CREATE TABLE gift_type (
  type_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
  type_name VARCHAR(100),
  type_description VARCHAR(200)
);

-- 创建赠品订单表 
CREATE TABLE gift_order (
  order_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
  gift_id INT,
  gift_amount INT,
  gift_price DECIMAL,
  FOREIGN KEY (gift_id) REFERENCES gift(gift_id)
);

-- 添加赠品 
INSERT INTO gift (gift_name, gift_amount, gift_description, gift_price) 
VALUES ('礼品1', 10, '这是一件很好的礼品', 99.99);

-- 编辑赠品 
UPDATE gift SET gift_name='礼品B' WHERE gift_id=1;

-- 删除赠品 
DELETE FROM gift WHERE gift_id=1;

-- 添加订单赠品 
INSERT INTO gift_order (order_id, gift_id, gift_amount, gift_price) 
VALUES (1, 1, 1, 99.99);

-- 查询赠品列表 
SELECT * FROM gift;

-- 查询赠品类型列表 
SELECT * FROM gift_type;

-- 查询订单赠品 
SELECT * FROM gift_order;