update tablea a, tableb b set a.bname=b.name where a.bid=b.id and a.id between 262 and 271
between 是>= and <=，即包含两个边界
update tablea a inner join tableb b on a.bid=b.id set a.bname=b.name where a.id between 262 and 271
本文共 276 字，大约阅读时间需要 1 分钟。
update tablea a, tableb b set a.bname=b.name where a.bid=b.id and a.id between 262 and 271
between 是>= and <=，即包含两个边界
update tablea a inner join tableb b on a.bid=b.id set a.bname=b.name where a.id between 262 and 271
转载于:https://www.cnblogs.com/drizzlewithwind/p/9299039.html