Navicat执行mysql脚本报错

1、错误日志

[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause 
	and contains nonaggregated column 'information_schema.PROFILING.SEQ' 
	which is not functionally dependent on columns in GROUP BY clause; 
	this is incompatible with sql_mode=only_full_group_by

2、解决方法

在Navicat客户端执行以下SQL：
		SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));