INSERT INTO city_country_sandbar(city_en,
city,
country,
capital,
sandbar,
latitude,
longitude) (SELECT
a.city_en,
a.city,
a.country,
b.capital,
b.sandbar,
a.latitude,
a.longitude
FROM
zfn_city_info a
LEFT JOIN zfn_country_info b ON a.country = b.country)
MySQL两张表数据合并插入到新的表中
最新推荐文章于 2024-05-31 19:53:24 发布