REPLACE INTO t_merchant_nature_info(F_NATURE_CODE, F_NATURE_NAME, F_NATURE_TYPE , F_STATE, F_IS_MODIFY, F_IS_SHOW_AND_NECESSARY) VALUES ('10000001','????????','2','1','0','1'); REPLACE INTO t_merchant_nature_info(F_NATURE_CODE, F_NATURE_NAME, F_NATURE_TYPE , F_STATE, F_IS_MODIFY, F_IS_SHOW_AND_NECESSARY) VALUES ('10000002','???????','1','1','0','1'); REPLACE INTO t_merchant_nature_option_info(F_OPTION_CODE, F_NATURE_CODE, F_OPTION_NAME, F_OPTION_VALUE_BEGIN, F_OPTION_VALUE_END, F_OPER_CODE, F_OPER_TIME) SELECT CONCAT('100000000',F_BABY_STAGE_TYPE), '10000001', F_BABY_STAGE_NAME, F_BABY_STAGE_START_VALUE, F_BABY_STAGE_END_VALUE, 'KZ', '20170101121212' FROM t_cus_baby_stage WHERE F_BABY_STAGE_TYPE !=0 AND F_BABY_STAGE_TYPE<10 UNION SELECT CONCAT('10000000',F_BABY_STAGE_TYPE), '10000001', F_BABY_STAGE_NAME, F_BABY_STAGE_START_VALUE, F_BABY_STAGE_END_VALUE, 'KZ', '20170101121212' FROM t_cus_baby_stage WHERE F_BABY_STAGE_TYPE !=0 AND F_BABY_STAGE_TYPE>=10 UNION SELECT '100000020', '10000002', '??',0, 0, 'KZ', '20170101121212' UNION SELECT '100000021', '10000002', '?',0, 0, 'KZ', '20170101121212'; REPLACE INTO t_cus_nature_option_info (F_CUS_CODE, F_NATURE_CODE, F_NATURE_VALUE) SELECT F_CUS_CODE, '10000001', F_BABY_BIRTHDAY FROM t_cus_info WHERE F_BABY_BIRTHDAY IS NOT NULL AND F_BABY_BIRTHDAY != '' UNION SELECT F_CUS_CODE, '10000002', CASE WHEN F_BABY_GENDER = 0 THEN '100000020' WHEN F_BABY_GENDER = 1 THEN '100000021' END FROM t_cus_info WHERE F_BABY_GENDER IS NOT NULL AND F_BABY_GENDER != '';