How to insert a random integer number, for a given column and several rows

Question

I was wondering.. Is it possible, with a SQL query, to:

generate randomly, a list of integer number
insert this in a table, for a specific column, and for multiple rows

I didn't try anything, to be honest I was just asking myself the question.

EDIT: (from a comment)

Imagine that I have a table USERS, with a field named VOTES. For every users, I want to insert, in the column VOTES, a random integer number between 0 and 15. For the record, I'm working with MySQL 5.5 | MariaDB

Thanks for your answers

Provide sample data to be clear what do you want to achieve. — Stanislovas Kalašnikovas
– Stanislovas Kalašnikovas, Commented May 23, 2019 at 10:22
Imagine that I have a table USERS, with a field named VOTES. For every users, I want to insert, in the column VOTES, a random integer number between 0 and 15. For the record, I'm working with MySQL 5.5 | MariaDB — Chris_1985
– Chris_1985, Commented May 23, 2019 at 10:33
You shouldn't add question details in a comment. You should edit your question. Click on the edit link below the tags in your question. — Abra
– Abra, Commented May 23, 2019 at 10:35

Stanislovas Kalašnikovas · Accepted Answer · 2019-05-23 10:50:59Z

2

If you want to update the column named votes in the table users with random integers between 0 and 15, you could do it in the following:

UPDATE users
    SET votes = FLOOR(RAND() * 16)

edited May 23, 2019 at 10:50

answered May 23, 2019 at 10:24

Stanislovas Kalašnikovas

9,0735 gold badges36 silver badges60 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to insert a random integer number, for a given column and several rows

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related