[STS,스프링] STS에서 schema.sql, data.sql 만들기

마켓플레이스에서 sql Editor를 받으세요.

 

import.sql  파일을 만듭니다.

insert into skill(id, skillname, parent_skill_id, is_field) values (1, "WEB", null, true)
insert into skill(id, skillname, parent_skill_id, is_field) values (2, "SAP", null, true)
insert into skill(id, skillname, parent_skill_id, is_field) values (3, "java", 1, false)
insert into skill(id, skillname, parent_skill_id, is_field) values (4, "C#", 1, false)
insert into skill(id, skillname, parent_skill_id, is_field) values (5, ".NET", 1, false)
insert into skill(id, skillname, parent_skill_id, is_field) values (6, "PHP", 1, false)
insert into skill(id, skillname, parent_skill_id, is_field) values (7, "Javascript", 1, false)
insert into skill(id, skillname, parent_skill_id, is_field) values (8, "RDBMS", 1, false)
insert into skill(id, skillname, parent_skill_id, is_field) values (9, "JSP", 3, false)
insert into skill(id, skillname, parent_skill_id, is_field) values (10, "SPRING", 3, false)
insert into skill(id, skillname, parent_skill_id, is_field) values (11, "ORACLE", 8, false)
insert into skill(id, skillname, parent_skill_id, is_field) values (12, "ABAP", 2, false)
insert into skill(id, skillname, parent_skill_id, is_field) values (13, "FI", 12, false)
insert into skill(id, skillname, parent_skill_id, is_field) values (14, "BW", 12, false)
insert into skill(id, skillname, parent_skill_id, is_field) values (15, "SCM", 12, false)

 

ddl-auto: create로 하고 실행하면 sql 파일이 import됩니다.

 

출처 : https://stackoverflow.com/questions/64783789/where-are-the-sql-development-tools-for-the-eclipse-ide-and-spring-tools-suite