I am learning Spring Framework from online tutorials. In the tutorial, the instructor is using Spring JDBC and the H2 database and a data.sql file to populate tables. He also changed the dialect from "General SQL" to "MySQL" dialect as we are going to use MySQL in future videos, so I am just following the tutorial.
All just went well, but when I created data.sql and changed the dialect in my classpath, I was getting errors on a table name like this:
Unable to resolve <table> and table names and columns are showing in red color as errors.
I don't know what's happening, and I have tried every solution on the Internet. I am attaching my source code and data.SQL screenshot.