(SQL) INSERT INTO가 안되면 REPLACE INTO로

11:22:27 INSERT INTO e1_config.2_3_1. recipe_safety_info_by_steptype SELECT * FROM e3-2_config.2_3_1. recipe_safety_info_by_steptype Error Code: 1062. Duplicate entry '1' for key '2_3_1. recipe_safety_info_by_steptype.PRIMARY' 0.000 sec

 

에러 발생 시 

 

기존 값은 덮어쓰기 (REPLACE INTO)

REPLACE INTO `e1_config`.`2_3_1. recipe_safety_info_by_steptype`
SELECT * FROM `e3-2_config`.`2_3_1. recipe_safety_info_by_steptype`;