[spring boot] schema.sql, data.sql 사용하기

 

resources 폴더에 아래 2개 파일을 만든다

-- resources/schema.sql

create table tb_atest (
    name varchar(20) primary key,
    reg_ts timestamp
);

-- resources/data.sql

insert into tb_atest (name, reg_ts) values ('aa', now());
insert into tb_atest (name, reg_ts) values ('bb', now());
insert into tb_atest (name, reg_ts) values ('cc', now());

 

application.yml 에서 옵션을 활성화한다

# resources/application.yml

spring.sql.init.mode: always