Insert (multiple) new rows into a table from another table using a subquery?

Question

So this is the query I am trying, definately doesnt work.

The subquery returns 3 rows, which I want copied to the new table.

INSERT INTO retired
VALUES (SELECT * from questions where status = 'R');

I was sure looking at it I was doing it wrong, but here is specifically the question:

Do I need to list all the columns separately, or is there a way to tell it just to move the whole row? The tables attributes and columns are identical.

Duplicate - see this: stackoverflow.com/questions/9692319/… — citizenen
– citizenen, Commented Jul 25, 2014 at 1:03

Mariano D'Ascanio · Accepted Answer · 2014-07-25 01:07:38Z

3

If questions and retired have the same columns (quantity and type), then this should work:

INSERT INTO retired
SELECT * from questions where status = 'R';

answered Jul 25, 2014 at 1:07

Mariano D'Ascanio

1,2002 gold badges16 silver badges17 bronze badges

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

1 Comment

user3175451 Over a year ago

I see what I did wrong. Thank you. I guess I didnt realize I would not need VALUES to do it this way.

Collectives™ on Stack Overflow

Insert (multiple) new rows into a table from another table using a subquery?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related