Spring import sql

-- You can simply create a data.sql file in your src/main/resources folder 
-- and it will be automatically executed on startup. 
-- In this file you just add some insert statements, eg.:

INSERT INTO users (username, firstname, lastname) VALUES
  ('lala', 'lala', 'lala'),
  ('lolo', 'lolo', 'lolo');
  
-- If you're using Spring boot 2, database initialization only works for 
-- embedded databases (H2, HSQLDB, ...). If you want to use it for other 
-- databases as well, you need to change the 
-- spring.datasource.initialization-mode property:

spring.datasource.initialization-mode=always

Source: stackoverflow.com

Spring where to put the data sql

-- You can simply create a data.sql file in your src/main/resources folder 
-- and it will be automatically executed on startup. 
-- In this file you just add some insert statements, eg.:

INSERT INTO users (username, firstname, lastname) VALUES
  ('lala', 'lala', 'lala'),
  ('lolo', 'lolo', 'lolo');
  
-- If you're using Spring boot 2, database initialization only works for 
-- embedded databases (H2, HSQLDB, ...). If you want to use it for other 
-- databases as well, you need to change the 
-- spring.datasource.initialization-mode property:

spring.datasource.initialization-mode=always

Source: stackoverflow.com

Similar codes

1 vote329 views1 answer
Postgresql must appear in the group by clause or be used in an aggregate function
SQL
2 votes321 views3 answers
How to pass password mysql command line
SQL
0 vote330 views1 answer
Database xml sql
SQL
2 votes312 views5 answers
Alter table primary key postgresql
SQL
16 votes360 views6 answers
Mysql find duplicates in same table
SQL
0 vote314 views1 answer
Mysql function variable
SQL
1 vote319 views1 answer
Mysql change root mysql_native_password
SQL
1 vote320 views3 answers
How to truncate foreign key constraint table
SQL
0 vote327 views1 answer
Oracle DROP PROGRAM
SQL
0 vote317 views1 answer
A network or instance-specific error sql server
SQL