MySQL批量更新一个字段的值为随机数

 1 $arr = [];
 2 $str = ‘‘;
 3 for ($i=0; $i < 2660; ++$i)
 4 {
 5     $str .= " WHEN ".$i." THEN ".rand(0,50);
 6     $arr[] = $i;
 7 }
 8 //WHEN 1 THEN 3
 9 $arr = implode(‘,‘,$arr);
10 // var_dump($arr);die;
11 $sql = "UPDATE `ez_deichmann_original_goods_temp` SET `qty`= CASE id ".$str." END WHERE id IN ({$arr})";
12 var_dump($sql);die;
13 $res = mysqli_query($conn,$sql);
14 if ($res) {
15     echo ‘00000000000000‘;
16 }else{
17     echo ‘111111111‘;
18 }