追踪sql语句

http://t.zoukankan.com/xs-yqz-p-13131940.html

运行设置:

select version(),
@@sql_mode;SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
SHOW VARIABLES LIKE "general_log%"

开启日志：

SET GLOBAL log_output = 'TABLE'; SET GLOBAL general_log = 'ON';

查询日志:

SELECT * from .general_log ORDER BY event_time DESC

清空日志:

truncate table .general_log;