UPDATE base_build_le_shan AS a
INNER JOIN (
SELECT
SERIAL_NO,
ID
FROM
base_land_le_shan
) AS b ON a.SERIAL_NO = b.SERIAL_NO
SET a.LAND_ID = b.ID
sql关联更新
最新推荐文章于 2024-07-22 15:27:09 发布
UPDATE base_build_le_shan AS a
INNER JOIN (
SELECT
SERIAL_NO,
ID
FROM
base_land_le_shan
) AS b ON a.SERIAL_NO = b.SERIAL_NO
SET a.LAND_ID = b.ID