[Solved] Springboot Error: sprintgboot Unknown column ‘name’ in ‘field list’

When querying data using springboot + mybati plus, an error occurs springgboot unknown column 'field name' in 'field list'

Baidu hasn’t found a solution for a long time. Finally, it found that there was a problem with the setting of database field name


When the database configuration is correct and automatic map mapping is enabled, an error is still reported.

After checking for a long time, I finally found that there was a problem with the setting of the database field name

For example, the field name of my database is LastName. If the variable name in the JavaBean is LastName, an error will be reported.

Changing the database field name to underline or non hump name successfully solves the problem

Similar Posts: