MySQL update select
2023-09-19 本文已影响0人
暴风鱼
UPDATE
sheet1 AS dest,
(
SELECT
id,tyshxxdm
FROM
tab_qyzcxx
) AS src
SET
dest.qyid = src.id
where dest.统一社会信用代码
= src.tyshxxdm
UPDATE
sheet1 AS dest,
(
SELECT
id,tyshxxdm
FROM
tab_qyzcxx
) AS src
SET
dest.qyid = src.id
where dest.统一社会信用代码
= src.tyshxxdm