Project name: ssm_test
Problem description: When using pagehelper, an error is reported 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’
Solution: in the xxxmapper.xml file There is one more semicolon in the query statement, just delete
it. Reason: Because the PageHelper plugin will splicing limit after the query statement, resulting in an error

<select id="getById" resultMap="goodsResultMap">
        select * from tbl_goods;limit 1,5;
    </select>

Read More:

• Mybatis Error: Cause: java.sql.SQLException: sql injection violation, syntax error: syntax error, expect EQ
• [error record] Android application release package error handling (turn off syntax check log processing release configuration)
• [Solved] Keil Error: *** ERROR L250: CODE SIZE LIMIT IN RESTRICTED VERSION EXCEEDED
• [Solved] spring boot – JPA–H2 Error: H2 error: “Syntax error in SQL statement … expected identifier“
• Introduce wangeditor5 to run an error: You may need an appropriate loader to handle this file type (es6 compatibility issue)
• How to Solve DB2 uses Limit Error
• Vscode configures eslint to solve terminal syntax error
• ‘pre-mature EOF‘ : syntax error syntax error [How to Solve]
• [Solved] Mybatis uses the PageHelper paging plugin error: Could not find method on interface ibatis.executor.Executor named query.
• Template cannot be rendered due to the joint query of populate in mongoose: syntax error: unexpected token r in JSON at position 0
• SQL Server Error: Arithmetic overflow error converting expression to data type int.
• How to Fix Microsoft SQL Server Error 1326
• How to Solve Altium designer Rule Check Without an Error Issue
• MySQL error: starting MySQL… The server quit without updating PID file
• How to Solve Error: “syntax error near unexpected token `newline’”
• DB2 detects a syntax error in the DRDA data stream: 0x3 ERRORCODE= -4499, SQLSTATE=58009
• [Solved] ANTRL Compile HiveLexer.g File Error: syntax error: antlr: NoViableAltException(@[])
• [Solved] Wepy build watch Error: ERR! Parse WePY config failed. Are you trying to use
• file_name.sh: 3: Syntax error: “(“ unexpected [How to Solve]
• [Solved] The version of springcloud must support the current version of springboot, otherwise the startup project will report an error: error starting ApplicationContext