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
本文标题：MySQL update select
本文链接：https://www.haomeiwen.com/subject/wsnnvdtx.html
网友评论