mysql的查询记录在哪里

SET GLOBAL general_log = 'ON';
SET GLOBAL log_output = 'TABLE'; -- 可以是 'TABLE', 'FILE' 或 'NONE'

SELECT * FROM mysql.general_log;

SET GLOBAL slow_query_log = 'ON';
SET GLOBAL long_query_time = 2; -- 设置阈值为2秒
SET GLOBAL log_output = 'TABLE'; -- 可以是 'TABLE', 'FILE' 或 'NONE'

SELECT * FROM mysql.slow_log;

SHOW BINARY LOGS;

CREATE TABLE user_log (
    id INT AUTO_INCREMENT PRIMARY KEY,
    user_id INT,
    action VARCHAR(255),
    action_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

DELIMITER $$
CREATE TRIGGER after_user_update
AFTER UPDATE ON users
FOR EACH ROW
BEGIN
    INSERT INTO user_log (user_id, action) VALUES (OLD.id, 'updated');
END$$
DELIMITER ;