CODEWITHSUNDEEP
mysqlsqlrandomsql-update
dcpartners
dcpartners

Reputation: 5446

Update column with random value

I have a table:

ID | VALUE | DATE
1  | 5     | 2012-10-01 
2  | 7     | 2012-10-02
3  | 3     | 2012-10-05
4  | 0     | 2012-05-07

I want to add on the top of the current value with the VALUE random individually BETWEEN 1 AND 5.

Let say:

ID | VALUE | RANDOM VALUE
1  | 5     | 0
2  | 7     | 2
3  | 3     | 3
4  | 0     | 6

NEW VALUE

ID | VALUE 
1  | 5     
2  | 9     
3  | 6     
4  | 6

How do I do this? All I can think of is by doing cursor type of query.

Any help?

Upvotes: 5

Views: 10672

Answers (2)

ppeterka
ppeterka

Reputation: 20726

Try

UPDATE TABLE SET VALUE=VALUE+ROUND(1+RAND()*4);

Upvotes: 6

PyQL
PyQL

Reputation: 1830

This will update the value by a random value between 1 and 5

UPDATE TABLEA SET VALUE=FLOOR(RAND()*5)+1

Upvotes: 5

Related Questions