Random number in mysql

For generating a random number between any two numbers we can use below code

update gurtestimonials set testrating = 5 – FLOOR( RAND( ) * ( 5 -4 +1 ) );

maxnum-FLOOR( RAND( ) * ( maxnum?-minnum +1 ) );

Leave a Reply

Your email address will not be published. Required fields are marked *