Fun at zangOOr Click Here
1 like 0 dislike
38 views

I would like to update the column count by any random values between 20 to 2000

Existing table records

column1       column2
Expense1   20
Expense2 35

Need output

column1       column2
Expense1   220
Expense2 550
in Education & Reference by (950 points) | 38 views

1 Answer

0 like 0 dislike
Best answer

update table set column= FLOOR(RAND()*(2000-20+1))+20

by (3.3k points)

Related questions

1 like 0 dislike
1 answer
1 like 0 dislike
1 answer
1 like 0 dislike
1 answer
2 like 0 dislike
1 answer
2 like 0 dislike
1 answer
0 like 0 dislike
1 answer
1 like 0 dislike
1 answer
1 like 0 dislike
1 answer
1 like 0 dislike
1 answer

Where your donation goes
Technology: We will utilize your donation for development, server maintenance and bandwidth management, etc for our site.

Employee and Projects: We have only 15 employees. They are involved in a wide sort of project works. Your valuable donation will definitely boost their work efficiency.

How can I earn points?
Awarded a Best Answer 10 points
Answer questions 10 points
Asking Question -20 points

1,245 questions
1,400 answers
565 comments
4,809 users