mysql 查询登入记录

CREATE TABLE login_records (
    id INT AUTO_INCREMENT PRIMARY KEY,
    user_id INT NOT NULL,
    login_time DATETIME NOT NULL,
    ip_address VARCHAR(50) NOT NULL
);

SELECT * FROM login_records WHERE user_id = 123 ORDER BY login_time DESC;

CREATE INDEX idx_user_id ON login_records(user_id);
CREATE INDEX idx_login_time ON login_records(login_time);

START TRANSACTION;
SELECT * FROM login_records WHERE user_id = 123 FOR UPDATE;
-- 其他操作
COMMIT;

ALTER TABLE login_records PARTITION BY RANGE (TO_DAYS(login_time)) (
    PARTITION p0 VALUES LESS THAN (TO_DAYS('2020-01-01')),
    PARTITION p1 VALUES LESS THAN (TO_DAYS('2021-01-01')),
    PARTITION p2 VALUES LESS THAN MAXVALUE
);