MySQL/SQLite insert same random # to multiple rows

Question

MySQL/SQLite

I want to insert a randomly generated number (of 9 positions) into multiple rows BUT they need to be the same for all rows matched in the query.

update products set tag_seed=( SELECT ABS(RANDOM() % 999999999) ) where [...];

Partialy works... Each row will have a different random number. I need them to be same.

Glenn Vandamme · Accepted Answer · 2013-06-08 23:36:35Z

up vote 0 down vote accepted

This is logical since you will generate a new random for every update query. The easiest solution is to generate a random integer, store it in a local variable and use that variable in your queries:

SET @rand := (SELECT ABS(RAND() * 1000000000));
update products set tag_seed=@rand where [...];

answered Jun 8 '13 at 23:36

Glenn Vandamme
354115

Thanks. Is it possible in SQLite? – user590584 Jun 9 '13 at 0:34

SQLite does not support local variables as far as i know, you could store the random in a variable of your program though, or use a temp table with one field in which you temporarily store your value. Then you can fetch it in your update query using a subquery. – Glenn Vandamme Jun 9 '13 at 10:19

add a comment |

asked	1 year ago
viewed	81 times
active	1 year ago

current community

your communities

more stack exchange communities

MySQL/SQLite insert same random # to multiple rows

1 Answer 1

Your Answer

Hot Network Questions

current community

your communities

more stack exchange communities

MySQL/SQLite insert same random # to multiple rows

1 Answer 1

Your Answer

Sign up or log in

Post as a guest

Related

Hot Network Questions