update area_payment ap
inner join area_payment_bak4 ap4
on ap.id = ap4.id
inner join area_payment_old old
on old.id = ap4.id
and ap.id>1
set ap.`wt_caps_price` = old.`wt_caps_price`,
ap.`wt_over_price` = old.`wt_over_price`
表连接更新
update area_payment ap
inner join area_payment_bak4 ap4
on ap.id = ap4.id
inner join area_payment_old old
on old.id = ap4.id
and ap.id>1
set ap.`wt_caps_price` = old.`wt_caps_price`,
ap.`wt_over_price` = old.`wt_over_price`
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
扫一扫
