How to insert same records from one table to another table 4 to 5 times randomly

Question

table 1 is my current table. newtable is what needs to be insert into.

Here's the example: Table 1

a
b
c
d

newTable

a
a
a
a
b
b
b
b
b
c
c
c
c
c
d
d
d
d

So far you have an Oracle answer and a MySQL answer. You might want to tag the actual database this needs to be done in. — Nick.McDermaid, Sep 16 '14 at 23:58
i have the answer. thanks! Use a random function: SELECT FLOOR(RAND()*(6-4)+4). then put an insert statement in a loop. — user1376261, Sep 17 '14 at 13:34

Bulat · Answer 1 · 2014-09-17T06:55:17.180

0

Try this in Oracle:

SELECT x, LEVEL from myTable t
        CONNECT BY LEVEL <= ROUND(DBMS_RANDOM.VALUE (4, 5))
and prior x = x
and prior sys_guid() is not null;

edited Sep 17 '14 at 06:55

answered Sep 16 '14 at 23:38

Bulat

score -1 · Answer 2 · edited May 23 '17 at 11:49

-1

If you are using mysql;

select * from table order by rand() limit 3
then
Insert it into new new table

Do it many times as you want.

You can follow previous post

Thank You,

Sameera

edited May 23 '17 at 11:49

Community

answered Sep 16 '14 at 21:45

Sameera Silva

Possibly you meant `INSERT INTO newtable SELECT * FROM table ...` ? – LSerni Sep 16 '14 at 21:53
yes, if want it more random, limit it to 1 record and insert. you can loop it for 4-5 times – Sameera Silva Sep 16 '14 at 21:55

2 Answers2