原文:https://blog.lmlyz.online
单列:
update student s, city c
set s.city_name = c.name
where s.city_code = c.code;
多列:
update a, b
set a.title=b.title, a.name=b.name
where a.id=b.id
MySQL 从一张表update字段到另外一张表中
最新推荐文章于 2023-02-27 14:10:08 发布
原文:https://blog.lmlyz.online
单列:
update student s, city c
set s.city_name = c.name
where s.city_code = c.code;
多列:
update a, b
set a.title=b.title, a.name=b.name
where a.id=b.id