[JAVA] MySQL error in Spring Unknown column'Value 1'in'field list'

In Spring Java Entity

Unknown column'value 1'in'field list'

Came out and was addicted to it.

From the conclusion, the problem was that the capital letters were mixed.

If you pour SQL directly into MySQL from the terminal, it works fine with uppercase letters, When I try to call it from a Spring + Java program, I get an error that there are no columns.

If you specify a specific column name that there is no field, be careful that the columns are not mixed with Japanese or uppercase letters.

Recommended Posts

MySQL error in Spring Unknown column'Value 1'in'field list'
Unknown error in line 1 of pom.xml when using Spring Boot in Eclipse
MySql connection error
Stumble in MySQL 5.5-> 5.7
I get Mysql2 :: Error :: ConnectionError in the production environment