订单管理中根据订单来源批量修改服务部门

 ddly ='交易平台' and serviceDept is null

--SELECT * from de_tbfw_order where ddly ='交易平台' and serviceDept is null
UPDATE de_tbfw_order set serviceDept =(SELECT id from de_tbfw_order_servicedept where NAME ='交易平台')
WHERE ddly ='交易平台' and serviceDept is null

posted on 2014-11-21 09:03  w z y  阅读(210)  评论(0编辑  收藏  举报