php实现批量分批次链表更新
$i = 0;
$sql = $sql_pre = "UPDATE term AS t LEFT JOIN rewrite_url AS rON t.ID = r.OptDataId
SET t.ThirtyDayRev = CASE r.RequestPath ";
$url = array();
foreach ($page_commission as $key =>$value ){
$i++;
$value = number_format($value,2);
$sql .=" WHEN '{$key}' THEN t.ThirtyDayRev + $value ";
$url[] = "'{$key}'";
if($i % 3000 == 0){
$sql .= " END WHERE r.RequestPath IN (".join(',',$url).")";
$www_db->query($sql);
$sql = $sql_pre;
$coupon_ids = array();
}
}
if($sql != $sql_pre){
$sql .= " END WHERE r.RequestPath IN (".join(',',$url).")";
$www_db->query(substr($sql,0,-1));
}