UPDATE user_account AS A,
user_info AS B
SET A.reg_device = B.reg_device,
A.reg_time = B.reg_time,
A.`reg_ip` = B.`reg_ip`,
A.`reg_source` = B.`reg_source`,
A.`source` = B.`source`,
A.`last_login_time` = B.`last_login_time`,
A.`first_login_time` = B.`first_login_time`,
A.`first_bind_time` = B.`first_bind_time`
WHERE
B.user_guid = A.user_guid
通过一个表修改另一个表数据,对拷
最新推荐文章于 2023-06-19 20:55:31 发布