mysql跨库查询及批量修改

SELECT a.kefu_id,b.kefu_id FROM roncoo_education_course.`order_info` a JOIN roncoo_education_user.`user_ext` b ON a.`user_no`=b.`user_no`;


UPDATE order_info as aa INNER JOIN
(SELECT a.id,b.kefu_id FROM roncoo_education_course.`order_info` a JOIN roncoo_education_user.`user_ext` b ON a.`user_no`=b.`user_no`)bb on aa.id = bb.id set aa.kefu_id = bb.kefu_id

mysql跨库查询及批量修改

上一篇:mysql 忘记root密码


下一篇:CRM 营销自动化 销售合格线索SQL和营销合格线索MQL的区别