UPDATE all records with a random number from a range

by

Try this:

UPDATE tableName SET columnName = FLOOR( 1 + RAND( ) *3 );

From the MySQL documentation for RAND:

Returns a random floating-point value v in the range 0 <= v < 1.0.

So in the above query, the largest value which could be generated by 1 + RAND()*3 would be 3.999999, which when floored would give 3. The smallest value would occur when RAND() returns 0, in which case this would give 1.

More Related Contents:

  1. MySQL select 10 random rows from 600K rows fast
  2. How can i optimize MySQL’s ORDER BY RAND() function?
  3. quick selection of a random row from a large table in mysql
  4. Simple Random Samples from a Sql database
  5. Selecting random rows with MySQL
  6. How does MySQL’s ORDER BY RAND() work?
  7. How to select one row randomly taking into account a weight?
  8. quick selection of a random row from a large table in mysql
  9. Simple Random Samples from a MySQL Sql database
  10. Insert/ Update random date in MySQL
  11. MYSQL Select One Random record from each Category
  12. How to get mysql random integer range?
  13. mysql unique number generation
  14. what will be the sql query code of this “Healthcare” database?
  15. Rank function in MySQL
  16. MySQL: Alternatives to ORDER BY RAND()
  17. Find nearest latitude/longitude with an SQL query
  18. ERROR 1130 (HY000): Host ” is not allowed to connect to this MySQL server [duplicate]
  19. ON DUPLICATE KEY + AUTO INCREMENT issue mysql
  20. What is this operator in MySQL?
  21. SELECT * WHERE NOT EXISTS
  22. How to fuzzy match email or telephone by Elasticsearch?
  23. Field ‘id’ doesn’t have a default value?
  24. “SELECT COUNT(*)” is slow, even with where clause
  25. Check if a column exists in a table with SQL
  26. What is the difference between SQL and MySQL? [closed]
  27. how to use a like with a join in sql?
  28. How to initialize mysql container when created on Kubernetes?
  29. Find duplicates in the same table in MySQL
  30. Auto-increment is not resetting in MySQL

Leave a Comment