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.