数据库存储双11优惠活动

-- 创建优惠信息表
CREATE TABLE promotions (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255) NOT NULL,
    discount DECIMAL(5, 2) NOT NULL,
    start_date DATE NOT NULL,
    end_date DATE NOT NULL
);

-- 插入一条优惠信息
INSERT INTO promotions (name, discount, start_date, end_date)
VALUES ('双11大促', 0.20, '2023-11-11', '2023-11-11');

// 连接到MongoDB数据库
const MongoClient = require('mongodb').MongoClient;
const url = 'mongodb://localhost:27017';
const dbName = 'ecommerce';

MongoClient.connect(url, function(err, client) {
    if (err) throw err;
    const db = client.db(dbName);
    const promotions = db.collection('promotions');

    // 插入一条优惠信息
    promotions.insertOne({
        name: '双11大促',
        discount: 0.20,
        startDate: new Date('2023-11-11'),
        endDate: new Date('2023-11-11')
    }, function(err, res) {
        if (err) throw err;
        console.log('优惠信息插入成功');
        client.close();
    });
});