Dynamically inserting multiple rows to a table

Question

I need to insert multiple records into a table. The number of records depend on the result of another query. For example:

INSERT INTO TABLE1(colm1, colm2, colm3)
VALUES(SELECT clom1 FROM TABLE2, constant, constant)

In this query colm2, colm3 have constsnt values, the value of colm1 differs based on the ouput of TABLE2, and the number of records that are to be inserted also depend upon the number of values from TABLE2. Can someone give me a solution?

Binary Worrier · Accepted Answer · 2022-09-08 12:14:34Z

8

INSERT INTO Table1(colm1,colm2,colm3)
SELECT colm1,constant,constant FROM TABLE2

This should work

edited Sep 8, 2022 at 12:14

Binary Worrier

51.8k20 gold badges144 silver badges187 bronze badges

answered Apr 29, 2011 at 9:11

TBohnen.jnr

5,1191 gold badge22 silver badges26 bronze badges

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

Comments

Binary Worrier · Accepted Answer · 2011-04-29 09:12:19Z

4

Try

INSERT INTO TABLE1(colm1, colm2, colm3) 
SELECT clom1, constant, constant FROM TABLE2
. . .

answered Apr 29, 2011 at 9:12

Binary Worrier

51.8k20 gold badges144 silver badges187 bronze badges

Collectives™ on Stack Overflow

Dynamically inserting multiple rows to a table

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related