SELECT * , CONVERT(sql_text USING utf8) AS sqldeatil FROM mysql.slow_log where start_time > '2019-09-17 09' and query_time >'00:01:00.000000' ORDER BY query_time DESC ;
CONVERT() 函数是将系统中的二进制直接转为对应可视化的sql
SELECT * , CONVERT(sql_text USING utf8) AS sqldeatil FROM mysql.slow_log where start_time > '2019-09-17 09' and query_time >'00:01:00.000000' ORDER BY query_time DESC ;
CONVERT() 函数是将系统中的二进制直接转为对应可视化的sql