举例:
客户系统里,需要将客户ID 1-500(客户字段ID为 id) 销售员ID设置为1,常规单条sql命令如下:
UPDATE `crm_customers` SET `admin_user_id` = '1' WHERE `crm_customers`.`id` = 4;
UPDATE `crm_customers` SET `admin_user_id` = '1' WHERE `crm_customers`.`id` = 5;
UPDATE `crm_customers` SET `admin_user_id` = '1' WHERE `crm_customers`.`id` = 6;
UPDATE `crm_customers` SET `admin_user_id` = '1' WHERE `crm_customers`.`id` = 7;
UPDATE `crm_customers` SET `admin_user_id` = '1' WHERE `crm_customers`.`id` = 8;
...
优化代码为:
UPDATE `crm_customers` SET `admin_user_id` = '1' WHERE `crm_customers`.`id` in(id);