MySQL implements the coupon management function of the ordering system

MySQL implements the coupon management function of the ordering system

With the rapid development of e-commerce, the ordering system has gradually become an important model in the catering industry. In order to attract more customers and improve user experience, ordering systems usually provide various promotions, among which coupons are a common promotion method. This article will focus on how to implement the coupon management function of the ordering system in the MySQL database and give specific code examples.

1. Create a coupon table

First, we need to create a table in the MySQL database to store coupon information. The table will contain fields such as the coupon's unique identifier, name, face value, expiration date, and more. The specific code is as follows:

CREATE TABLE coupons (
    id INT PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(100) NOT NULL,
    value DECIMAL(10, 2) NOT NULL,
    expire_date DATE NOT NULL
);

2. Insert coupon data

Next, we can insert some test data into the coupon table. For example, we insert two coupons, one with a face value of 10 yuan and valid until December 31, 2022, and the other with a face value of 20 yuan and valid until March 31, 2023. The specific code is as follows:

INSERT INTO coupons (name, value, expire_date) VALUES
    ('优惠券1', 10.00, '2022-12-31'),
    ('优惠券2', 20.00, '2023-03-31');

3. Query available coupons

In the ordering system, users can use coupons to enjoy discounts. Therefore, we need to add a function to query the currently available coupons. The specific code is as follows:

SELECT * FROM coupons WHERE expire_date >= CURDATE();

The above code will return all coupons with a validity period greater than or equal to the current date.

4. Delete expired coupons

In order to keep the database clean, we should delete expired coupons. The specific code is as follows:

DELETE FROM coupons WHERE expire_date < CURDATE();

The above code will delete all coupons with an expiration date less than the current date.

5. Update coupon information

Sometimes, we need to update coupon-related information, such as face value or validity period. The specific code is as follows:

UPDATE coupons SET value = 15.00, expire_date = '2023-06-30' WHERE id = 1;

The above code will update the face value of the coupon with id 1 to 15 yuan, and will be valid until June 30, 2023.

6. Summary

By using the MySQL database, we can easily implement the coupon management function of the ordering system. This article introduces specific code examples on how to create a coupon table, insert coupon data, query available coupons, delete expired coupons, and update coupon information. I hope these examples can help you implement a complete ordering system and improve user experience.

The above is the detailed content of MySQL implements the coupon management function of the ordering system. For more information, please follow other related articles on the PHP Chinese website!