本文主要是介绍数据订正批量修改,希望对大家解决编程问题提供一定的参考价值,需要的开发者们随着小编来一起学习吧!
//数据订正修改类型
update TwmCustomerOperationLogs set type = 2 WHERE customerCode in (SELECT customerCode from (select customerCode from TwmCustomerOperationLogs where operationContent like '%线索%') as twm)
//订正线索组织
update TwmCustomerOperationLogs tc RIGHT JOIN TwmClew twm on tc.customerCode = twm.clewCode set tc.organizationIds = twm.organizationIds
//订正客户组织
update TwmCustomerOperationLogs tc RIGHT JOIN TwmCustomerRecords twm on tc.customerCode = twm.customerCode set tc.organizationIds = twm.organizationIds
这篇关于数据订正批量修改的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!