在 MySQL 中，CREATE INDEX 和 ALTER TABLE … ADD INDEX 两种方式最终效果完全相同生产建议：使用 ALGORITHM=INPLACE, LOCK=NONE 在线创建索引（需引擎支持）ALTER TABLE users ADD INDEX idx_name (...

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

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