Insert multiple rows from select into another table

Question

let's say i have `table1(col1,col2,col3), the values to insert on col1 and col3 will be the same, but the values to insert on col2 come from the result of a select query.

How can i write my query so i can do this multiple insert at once ? Example of what the query should do :

col1  |  col2   | col3

 1        val1     0
 1        val2     0
 1        val3     0

Gordon Linoff · Accepted Answer · 2015-06-26 11:45:08Z

21

If I understand correctly, you would use insert . . .select:

insert into table1(col1, col2, col3)
    select 1, col2, 0
    from <your other query here>;

answered Jun 26, 2015 at 11:45

Gordon Linoff

1.3m62 gold badges705 silver badges857 bronze badges

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

2 Comments

Dhumil Agarwal Over a year ago

Can we add Where clauses in the select query here, because sometimes we may want to use only certain rows of second table ?

Gordon Linoff Over a year ago

@DhumilAgarwal . . . Yes, you can add a where clause to the select.

Collectives™ on Stack Overflow

Insert multiple rows from select into another table

1 Answer 1

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Related