SQL-批量查询并添加至其他表

-- 高风险地区信息插入
INSERT into
	t_risk_area (area,code,status)
SELECT
	city_name,
	city_id,
	1
FROM
	t_city_info
WHERE
	city_id IN (111111, 222222, 333333, 444444, 555555, 666666, 777777, 888888, 9999999);