SQL: Using data from one table to insert new data into another table

Question

I am trying to write a query to create a row in a table "tagmap" which will use a constant value "tagid" and the "id" of a row in table images. I want this to be done for each row in the other table.

I've tried quite a few things but essentially this is what I want to end up with:

INSERT INTO tagmap SELECT images.id FROM images (id, tagid, imageid) VALUES(tagid || images.id, tagid, images.id);

dmg · Accepted Answer · 2016-11-09 21:33:08Z

2

All you have to do is project the values you want to insert. No need for "values" when you are using select:

INSERT INTO tagmap(id, tagid, imageid) 
  SELECT 'tagid' || images.id, 'tagid', images.id FROM images;

answered Nov 9, 2016 at 21:33

dmg

4,5892 gold badges21 silver badges27 bronze badges

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

1 Comment

TheDarkVoid Over a year ago

Thanks, this much simpler And here I ended up creating a function with a for loop.

Collectives™ on Stack Overflow

SQL: Using data from one table to insert new data into another table

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