A
A
Alide2020-05-17 09:24:33
MySQL
Alide, 2020-05-17 09:24:33

How to fill VALUE in Mysql with a random number in a range?

There is a request like this:

INSERT INTO `slider`(`id`, `user_id`) VALUES (12,99);

How to make user_id filled with a random number in the range from 55 to 99 ?
What to write in VALUES instead of 99 to have a random number there?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
D
Dmitry Gordinskiy, 2020-05-17
@DmitriyGordinskiy

RAND

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question