批量更新数据

update table_a
Inner JOIN table_b
on table_a.id= table_b.id
set table_a.Duration = table_b.Duration

posted @ 2016-09-23 14:32  点点_滴滴  阅读(160)  评论(0)    收藏  举报