inserting multiple row in sql using subquery

Question

I want to insert multiple row using one insert sql query. I know it is possible to insert multiple row in one sql query.

I have written some query as
insert into test values ((select loan_id from loan_transaction_mcg))

but I received the error
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

Is there anyway to insert data like this way. I have single column in test table.

Note that the manual page mentions the corresponding syntax (INSERT ... SELECT) and has examples too. — Andriy M
– Andriy M, Commented Jul 30, 2012 at 12:05

Lieven Keersmaekers · Accepted Answer · 2012-07-31 07:07:41Z

2

Assuming your test table is already created and contains only a loan_id, all you have to do is drop values and remove the now redundant parentheses.

INSERT INTO test SELECT loan_id FROM loan_transaction_mcg

edited Jul 31, 2012 at 7:07

answered Jul 30, 2012 at 11:21

Lieven Keersmaekers

58.9k15 gold badges117 silver badges151 bronze badges

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

2 Comments

Dinup Kandel Over a year ago

why i have to remove parenthesis. i am confused on this.

Lieven Keersmaekers Over a year ago

@Dinupkandel - You don't actually have to but they are redundant. I'll edit the answer to better reflect that.

Collectives™ on Stack Overflow

inserting multiple row in sql using subquery

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related