Update records with random number

Question

I have a 200k rows mysql table, and a column with empty value, and i like to populate this column with random numbers from 1 to 10,000.

I don't know if its possible to have a query something like this:

UPDATE 'videos'
SET 'views' = rand(1,10000)

Answer 1

RAND() produces random float values from 0 to 1. Could you try this?

Update videos set views = CAST(RAND() * 10000 AS UNSIGNED)

Answer 2

Try this one. It can generate a random number between 1 to 10000.

UPDATE videos
SET views = FLOOR(rand() * 10000) + 1;