Mysql将其他表中的数据更新到指定表中
update tb set tb.字段= (select 字段 from tb1 where tb.字段1 = tb1.字段1);
update role set uid = (select ID from users where role.name=name);
update tb set tb.字段= (select 字段 from tb1 where tb.字段1 = tb1.字段1);
update role set uid = (select ID from users where role.name=name);
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步