Select and insert multiple record from selected values in MYSQL

Question

I am having a User table in which some records are available.

I want to select Id3 with this condition id<5 and insert 4 new rows in the User table with Id2=10000 a constant value
For example: consider row 1 which is having id=1,id2=200, and Id3=300, I want to insert a new record where Id2=10000 and Id3=300

Is there any way to avoid writing 4 insert statements manually. Please suggest to me.

Make it, say 5, instead of 100, and see meta.stackoverflow.com/questions/333952/… — Strawberry
– Strawberry, Commented Sep 23, 2020 at 11:09

GMB · Accepted Answer · 2020-09-23 10:57:06Z

1

Consider the insert ... select syntax:

insert into users (id, id2, id3)
select id, 200, id3
from users
where id <= 100

If would probably be safer to not take in account rows that already have id2 set to 200:

insert into users (id, id2, id3)
select id, 200, id3
from users
where id <= 100 and id2 <> 200

answered Sep 23, 2020 at 10:57

GMB

224k25 gold badges103 silver badges151 bronze badges

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

1 Comment

O. Jones Over a year ago

I think the OQ wants to insert many rows in one of his scenarios.

Collectives™ on Stack Overflow

Select and insert multiple record from selected values in MYSQL

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related