mysql限制抽奖次数

-- 创建抽奖记录表
CREATE TABLE lottery_records (
    user_id INT PRIMARY KEY,
    total_draws INT DEFAULT 0,
    last_draw_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

-- 更新用户的抽奖次数
DELIMITER //
CREATE PROCEDURE update_draw_count(IN user_id_param INT)
BEGIN
    DECLARE current_draws INT;
    SELECT total_draws INTO current_draws FROM lottery_records WHERE user_id = user_id_param;
    
    IF current_draws IS NULL THEN
        INSERT INTO lottery_records (user_id, total_draws) VALUES (user_id_param, 1);
    ELSEIF current_draws < 3 THEN -- 假设每个用户最多可以抽3次
        UPDATE lottery_records SET total_draws = total_draws + 1 WHERE user_id = user_id_param;
    ELSE
        SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = '抽奖次数已达上限';
    END IF;
END //
DELIMITER ;

-- 调用存储过程更新抽奖次数
CALL update_draw_count(1);