It can be clearly seen from the error message that this is a problem on sql

Well, in general, there are many reasons for this problem:

1. Maybe the code call method in your service is wrong (this is the lowest level error, and it is not easy to find…), directly above

Originally it was written as MMIC01.delete, which was my careless (no flash, haha)

2. It is also possible that one of your SQL statements is wrong (this is easier to find)

Compared with the previous question, this error is already executing the SQL statement, so you can put the executed SQL statement in the tool and run it, and you will know where the problem is.

Read More:

• nested exception is org.apache.ibatis.builder.BuilderException: Error evaluating expression [Solved]
• Caused by: java.sql.SQLTransientConnectionException: HikariPool-1 – Connection is not available, request timed out after 30005ms.
• [Solved] MYSQL 5.7 gruop by eRROR: this is incompatible with sql_mode=only_full_group_by
• [Solved] Caused by: java.sql.SQLException: Access denied for user ‘root‘@‘hadoop102‘ (using password: YES)
• MYSQL gruop by Error: this is incompatible with sql_mode=only_full_group_by
• [Solved] MySQL Error: “Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre”
• [MySQL] The principle of group by aggregation function and the reason for aggregation limitation SELECT list is not in GROUP BY clause and contains nonaggregated column
• [Solved] The number of rows returned by the mybatis UPDATE statement is always 1 or useaffectedrows = true
• [Solved] ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregate
• SQL Server Group sort de duplication row_ number() over ( PARTITION BY t1.col_ 2 ORDER BY 1 )
• [Solved] init datasource error, url: jdbc:mysql://lcoalhost:3306/test com.mysql.cj.jdbc.exceptions.Com
• [Solved] Error response from daemon: Conflict. The container name “/mysql is already in use by container
• [Two Methods] Ora-00904: invalid group by error identifier
• [Solved] MYSQL Start Project Error: this is incompatible with sql_mode=only_full_group_by
• Using Mybatis to connect to the database error: Loading class `com.mysql.jdbc.Driver‘. This is deprecated. The new driver···
• How to Solve MySQL version 5.7+ Group by group error
• [Solved] Druid connection pooling Error: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
• [Solved] ERROR com.alibaba.druid.pool.DruidDataSource – init datasource error, url jdbcmysql
• Error [err] is reported when redirecting_HTTP_HEADERS_SENT]: Cannot set headers after they are sent to the client
• [Solved] error {dataSource-1} init error java.sql.SQLException: com.mysql.cj.jdbc.Driver