INSERT INTO city_tb (name) SELECT '서울특별시' WHERE NOT EXISTS (SELECT 1 FROM city_tb WHERE name = '서울특별시');
SET @city_id = (SELECT id FROM city_tb WHERE name = '서울특별시');
INSERT INTO country_tb (city_id, name) SELECT @city_id, '종로구' WHERE NOT EXISTS (SELECT 1 FROM country_tb WHERE city_id = @city_id AND name = '종로구');
INSERT INTO district_tb (statutory_code, country_id, name) SELECT 1111010100, (SELECT id FROM country_tb WHERE city_id = @city_id AND name = '종로구'), '청운동' WHERE NOT EXISTS (SELECT 1 FROM district_tb WHERE country_id = (SELECT id FROM country_tb WHERE city_id = @city_id AND name = '종로구') AND name = '청운동');
INSERT INTO city_tb (name) SELECT '서울특별시' WHERE NOT EXISTS (SELECT 1 FROM city_tb WHERE name = '서울특별시');
SET @city_id = (SELECT id FROM city_tb WHERE name = '서울특별시');
INSERT INTO country_tb (city_id, name) SELECT @city_id, '종로구' WHERE NOT EXISTS (SELECT 1 FROM country_tb WHERE city_id = @city_id AND name = '종로구');
INSERT INTO district_tb (statutory_code, country_id, name) SELECT 1111010200, (SELECT id FROM country_tb WHERE city_id = @city_id AND name = '종로구'), '신교동' WHERE NOT EXISTS (SELECT 1 FROM district_tb WHERE country_id = (SELECT id FROM country_tb WHERE city_id = @city_id AND name = '종로구') AND name = '신교동');
INSERT INTO city_tb (name) SELECT '서울특별시' WHERE NOT EXISTS (SELECT 1 FROM city_tb WHERE name = '서울특별시');
이하 생략
Summary
Description
법정동코드 파일을 SQL로 변환
ver1 결과물 예시
ver2 결과물 예시
엔티티 제약조건 추가
Related Issue
Issue Number: close #14