Console error: your MySQL server version for the right syntax to use near ”at line 1

Reason: the database field and entity class field are inconsistent

The in the database is underlined, and the entity class uses the hump naming method.

Solution:

In the application.yml configuration file, turn on mybatis’ camel nomenclature conversion settings

The problem is solved

Read More:

• mybatis Error: All elements are null [How to Solve]
• [Solved] mybatis plus Insert Error: mybatis plus Error setting null for parameter #1 with JdbcType OTHER
• Not showing null elements JAVA [How to Solve]
• JUnit tests mybatis-plus error: null pointer [How to Solve]
• [Solved] Mybatis.generator error: Failed to execute goal org.mybatis.generator:mybatis-generator-maven-plugin:1.3.2
• [Solved] Mybatis Error: Could not find resource mybatis-conf.xml
• [Solved] Tk-Mybatis Error: tk.mybatis.mapper.MapperException:
• Mapper.xml Error: Error setting non null for parameter #3 with JdbcType null.
• Ruoyi-cloud Integrated mybatis-plus Error: Unknown column ‘search_value‘ in ‘field list‘
• mybatis-plus Common Error and Their Solution
• [Solved] Mybatis integrates PageHelper and uses sqlserver paging error
• [Solved] Mybatis Error: attempting to get column ‘XX’ from result set
• Mybatis plus configuration console prints complete SQL statement with parameters
• Mybatis sets the primary key Auto-Increment error: No setter found for the keyProperty
• [Solved] Mybatis-Plus Error: Invalid bound statement (not found)
• Ecilpse: All Common Shortcut keys
• Mybatisenumtypehandler upgrade error of mybatis plus
• [Solved] JavaErrors_mybatis collection column Pass Value Error
• Mybatis plus paging Plugin and Auto-fill
• mybatis “case when” Error: Failed to process, please exclude the tableName or statementId.