SQUIER (1055) : Expression #1 of SELECT list is not in GROUP BY clause and cor nonaggregated colum

在进行数据库操作时，出现以下报错问题

SQUIER (1055) : Expression #1 of SELECT list is 
not in GROUP BY clause and cor 
nonaggregated column ‘test jsqjtest:time’ which 
is not functionally dependent on columns in 
GROUP BY clause; this is incompatible with 
sql_mode=only full group_by

解决方案, 在mysql 中执行以下语句。

set sql_mode ='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';

再执行原有语句时，则通过~问题解决