SET GLOBAL log_output = 'TABLE';SET GLOBAL general_log = 'ON';
– 日志开启
SET GLOBAL log_output = 'TABLE';SET GLOBAL general_log = 'OFF';
– 日志关闭
– 查询MySql执行日志 limit分页可根据情况修改,table_name是执行的表名
SELECT CONVERT(argument USING utf8mb4) AS body from mysql.general_log
where CONVERT(argument USING utf8mb4) like '%table_name%'
ORDER BY event_time DESC
LIMIT 1 , 10;