将数据库表1中actual_commission_balance的值修改到表2中id为invite_user_id的balance中
UPDATE 表2 SET balance = (SELECT actual_commission_balance FROM 表1 WHERE invite_user_id = 表2.id) WHERE EXISTS (SELECT * FROM 表1 WHERE invite_user_id = 表2.id);
原文地址: https://www.cveoy.top/t/topic/wIt 著作权归作者所有。请勿转载和采集!