• java执行sql脚本

    import javax.sql.DataSource;@Autowiredprivate DataSource dataSource;ClassPathResource classPathResource = new ClassPathResource("xxx.sql");t...

    mysql sql_mode问题导致group by查询时报错

    group by查询的时候出现错误:java.sql.SQLSyntaxErrorException: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘inms_loc...