在循环sql查询时

Question

I am trying to update all of the rows in a table in my database with a different value. I am trying to while loop the query to do this. Here's what I have...

<?php
$rand = rand(100,150000);
$start = 1;
$start += $start;
$start2 = $start +1;
echo $start;
while($start =< 686) {
echo "UPDATE table_video SET total_view = $rand WHERE id BETWEEN $start AND $start2;";
};
?>

I am sure most of you should be able to look at my code and understand what I am trying to accomplish. I would like the assistance. Thank You very much!

Answer 1

Use the mySQL RAND() function, min and max your range for the random values. I belive on this case are (100,150000)

UPDATE table_video 
SET total_view =  ROUND( (RAND() * (max-min)) +min )
WHERE id BETWEEN 1 AND 686;