Tag Archives: Mysql database

Error querying database. Cause: java.sql.SQLSyntaxErrorException: Expression #2 of SELECT list is no

Error reporting for startup project:
error querying database Cause: java. sql. Sqlsyntaxerrorexception: expression #2 of select list is no…
solution:
Enter MySQL with CMD root account
execute commands in MySQL

SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

Or use other connection tools to connect (root permission is required);