Insert into table the selected columns from another table

Question

What query would insert the selected columns, for a desired value, from a table into another table?

Before Query

table1=>Colums(A,B,C)
  row1(a,b,1)
  row2(c,d,0)
  row3(e,f,1)

table2=>Columns(id,A,B)

After Query

table1 is unchanged.

table2(id,A,B)
  row1(id,a,b)
  row2(id,e,f)

I need to insert in table2 all the rows from table1 where 'C=1', C may equal 1 in multiple records.

Which RDBMS? MySQL? SQL Server? ...? – Joachim Isaksson May 15 '14 at 17:29 — Joachim Isaksson, May 15 '14 at 17:29

T McKeown · Answer 1 · 2014-05-15T17:40:56.113

11

INSERT INTO TABLE2(A,B,C)
SELECT A,B,C
FROM TABLE1
WHERE C = 1

edited May 15 '14 at 17:40

answered May 15 '14 at 17:22

T McKeown

1

Without `INTO` it will only work on SQL Server and MySQL, if you add `INTO` it will work pretty much on any database. – Joachim Isaksson May 15 '14 at 17:40

score 0 · Answer 2 · answered May 15 '14 at 17:24

0

you can also select all the columns into a table without creating it first:

SELECT *
INTO TABLE2
FROM TABLE1
WHERE C=1

answered May 15 '14 at 17:24

rbedger

2 Answers2