Spring Boot Tutorial 28 - Using data sql to Initialize the Database

This is the Best Spring Boot Tutorial Ever. Learn Spring Boot Today.

Find more lessons here and join me!

[cfv]

Thanks for drawing attention to how to write queries keeping in mind the order.

[nml]

the column headers do not match the data in the h2-console display. you did not explain this. I am getting referential integrity errors in user table and I think it's because you changed the user table field order but I can't see your user table in the video at this point, so I don't know if that's the problem.

[rajatjain]

I m making file of name data.sql but then it's not opening h2 database and localhost

[susmithakotla]

Getting error as table not found
Don't know how to resolve this
Same table name in data.sql and .Java file