1. The screenshot of error report is as follows:
2. According to the error report output, check the position after the token, which appears near the ID field. The reason is that after LZ updates the last attribute of the statement, there is an extra comma in front of the where keyword.
3. Solutions
Remove the comma in the red box in the screenshot of step 1.
Read More:
- [Solved] pagehelper Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘LIMIT 1’
- Mybatis Connect Database Error: Error querying database. Cause: java.sql.SQLException: The server time zone value..
- Java.sql.SQLException: ORA-02291: integrity constraint violated – par
- [Solved] Cause: java.sql.SQLException: TDengine ERROR (8000000b): Unable to establish connection
- [Solved] Caused by: java.sql.SQLException: Connections could not be acquired from the underlying database!
- [Solved] spring boot – JPA–H2 Error: H2 error: “Syntax error in SQL statement … expected identifier“
- [Solved] Laravel Create Data Table Error: Syntax error or access violation: 1071 Specified key was too long
- ‘pre-mature EOF‘ : syntax error syntax error [How to Solve]
- [Solved] Mybatis Error: Cause: org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapper Configuration.
- [Solved] Mybatis Plus 3.X injection logic delete logicsqlinjector error
- [Solved] Failed to bind properties under ‘spring.datasource.type‘ to java.lang.Class＜javax.sql.DataSource＞
- How to Solve Pycharm SQL Union Error
- Vscode uses /deep/ Syntax error [How to Solve]
- [Solved] Console error: syntax error: illegal return statement
- Refresh 404 after packaging Vue project, uncaught syntax error: unexpected token ＜
- file_name.sh: 3: Syntax error: “(“ unexpected [How to Solve]
- Flink SQL contains aggregation operators Error: you cannot print directly
- Vscode configures eslint to solve terminal syntax error
- How to Solve Error: “syntax error near unexpected token `newline’”
- Firefox: How to Solve Syntax error: invalid regexp group