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
原文：http://www.cnblogs.com/w8104254/p/4112011.html