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

Claim your Biolink Click Here
1 like 0 dislike
229 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 (1.1k points) | 229 views

1 Answer

0 like 0 dislike
Best answer

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

by (4.7k points)

Related questions

3 like 0 dislike
2 answers
I want to get the results whose count is equal to 1 - MYSQL COUNT = 1
asked May 25, 2021 in Education & Reference by Simmi (830 points) | 341 views
1 like 0 dislike
1 answer
SELECT only rows that contain any alphabetic characters in MySQL Table?
asked Mar 31, 2014 in Education & Reference by Yogi (460 points) | 258 views
1 like 0 dislike
1 answer
How to fetch the numericals values from alphanumeric in MySQL
asked Mar 12, 2014 in Education & Reference by Krish (1.1k points) | 285 views
1 like 0 dislike
1 answer
Delete all Duplicate Rows except for One in MySQL?
asked Mar 8, 2015 in Education & Reference by Sam (1.6k points) | 350 views
2 like 0 dislike
1 answer
How to replace the part of the string from one column in mysql databse?
asked May 12, 2020 in Education & Reference by Yogi (460 points) | 217 views
2 like 0 dislike
1 answer
How to get specific values from a STRING in MYSQL
asked May 12, 2021 in Education & Reference by Sam (1.6k points) | 291 views
0 like 0 dislike
1 answer
How to check Size of Databases [in MB] Mysql
asked Aug 6, 2013 in Education & Reference by Arvind | 740 views
1 like 0 dislike
1 answer
ERROR: The storage engine for the table doesn't support repair in MySQL
asked Oct 21, 2013 in Education & Reference by Simmi (830 points) | 2.3k views
1 like 0 dislike
1 answer
How to GRANT privileges to users in MySQL
asked Aug 31, 2013 in Computers & Internet by user | 802 views
0 like 0 dislike
1 answer
MySQL - Search a string in all fields from every table from a database
asked Sep 6, 2013 in Education & Reference by Asker | 2.0k views

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

Most popular tags

Related questions

1,312 questions
1,473 answers
569 comments
4,809 users