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:

• [Solved] Mybatis uses the PageHelper paging plugin error: Could not find method on interface ibatis.executor.Executor named query.
• SSH integration error: org.hibernate.hql.internal.ast.QuerySyntaxException: User is not mapped[……]
• Mavenzai install Error: There are test failures
• [How to Solve] Content with element type ‘mapper’ must match
• [Maven] Pom.xml error: Cannot detect Web Project version.
• DB::Exception: test: Authentication failed: [How to Solve]
• UserMapper.selectByPrimaryKey-Inline error solution
• [Solved] ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
• [Solved] There are test failures. Please refer to D:\Java_study\springboot\springboot-sugon-3\target\surefire-reports for the individual test results.
• How to Solve DB2 uses Limit Error
• CREATE VIEW must be the only statement in the batch [How to Solve]
• Mybatis error under Springboot project: Invalid bound statement (not found)
• [Solved] NPM Error: FATAL ERROR: Ineffective mark-compacts near heap limit Allocation failed
• [Solved] error Strings must use singlequote, error Extra semicolon、error Unexpected trailing comma
• How to Solve Expdp Error ORA-39126
• [Solved] ERROR #42601 syntax error at or near “)“
• ORA-08103: object no longer exists [How to Solve]
• How to Fix Common Arcpy Error
• Keil Compile Error: ..\OBJ\USART.axf: error: L6002U: Could not open file ..\obj\sys.o: No such file or directory
• SQL Server Error: Arithmetic overflow error converting expression to data type int.