mysql签到

CREATE UNIQUE INDEX idx_user_sign ON sign_table (user_id, sign_date);

START TRANSACTION;
SELECT COUNT(*) INTO @count FROM sign_table WHERE user_id = 1 AND sign_date = CURDATE();
IF @count = 0 THEN
    INSERT INTO sign_table (user_id, sign_date) VALUES (1, CURDATE());
END IF;
COMMIT;

CREATE INDEX idx_sign_date ON sign_table (sign_date);

-- 分区表示例
ALTER TABLE sign_table PARTITION BY RANGE (TO_DAYS(sign_date)) (
    PARTITION p202201 VALUES LESS THAN (TO_DAYS('2022-02-01')),
    PARTITION p202202 VALUES LESS THAN (TO_DAYS('2022-03-01')),
    PARTITION p202203 VALUES LESS THAN (TO_DAYS('2022-04-01')),
    PARTITION pmax VALUES LESS THAN MAXVALUE
);