从随机PHP整数填充SQL中的列的所有行

Question

I have a SQL database with data however would like to populate a certain field in every row with a different random integer.

The code works to populate the field with one single random integer therefore my question is how do you loop for each row while assigning it a random integer.

Edit: Populating it dependent on another field condition

PHP Code Snippet:

 $data = rand(intval(5000),intval(57000));
 echo $data;
 $sql = "UPDATE Test SET Projection = ".$data;
 mysqli_query($conn,$sql);
 echo "complete"

Answer 1

you're about to update table with random integer, use MySQL:

SELECT (FLOOR( 1 + RAND( ) * 100 )) -- returns random int in 1-100

your php code:

//$data = rand(intval(5000),intval(57000));
//echo $data;
$low = 5000 ; $high = 57000 ; $d = $high - $low ;
$sql = "UPDATE Test
        SET Projection = (FLOOR( $low +RAND()* $d ))
        WHERE DayColumn in ( 'Friday' , 'Saturday' , 'Sunday')
        ;" ;
mysqli_query($conn,$sql);
echo "complete"

If you want do some thing else based on this value, before updating or after, let me know to edit my answer.