现有表jcs_food_distribution,jcs_food,从jcs_food中查询food_code,enterprise_code,将其插入到jcs_food_distribution中
INSERT INTO jcs_food_distribution (food_code, enterprise_code) SELECT
food_code,
enterprise_code
FROM
jcs_food
如果只需要导入jcs_food_distribution中不存在的记录,可以用
INSERT INTO jcs_food (food_code, enterprise_code) SELECT
food_code,
enterprise_code
FROM
jcs_food
WHERE
NOT EXISTS (
SELECT
food_code
FROM
jcs_food_distribution
WHERE
jcs_food_distribution.food_code = jcs_food.food_code
)