Getting data from one table and transferring it to another

Question

0.00/5 (No votes)

See more:

Hi,
I am currecntly working with HeidiSQL, and my problem is that I cannot figure out how to get data from one table, and insert it into a different table that has the same column names...
My query so far is:

SQL

INSERT INTO tbltransactions (TransactionID, TransactionDate, PaymentMethod, CashTendered, CustomerID)
SELECT (trans_id, date_time, payment_method, cash_tendered, customer_id) FROM shop_transactions

Just wondering whether anyone can see the error I am making here as I can't! The error message that appears is:

SQL Error (1241): Operand should contain 1 column(s)

Thanks guys,
Tom.

Posted 28-Sep-11 0:12am

thomasriley

Updated 28-Sep-11 0:18am

André Kraak

v2

Add a Solution

4 solutions

Solution 3

I don't believe it, it worked! Such a minor error aswell, been scanning through it for ages to find the fix!

Thanks Mehdi,
Tom.

Posted 28-Sep-11 0:27am

thomasriley

Comments

André Kraak 28-Sep-11 5:31am

If you have a question about or comment on the given solution use the "Have a Question or Comment?" option beneath the solution. When using this option the person who gave the solution gets an e-mail message and knows you placed a comment and can respond if he/she wants.

Please move the content of this solution to the solution you are commenting on and remove the solution. Thank you.

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mehdi Gholam · Accepted Answer · 2011-09-28T00:25:00

Solution 1

Try removing the () around the columns :

SQL

INSERT INTO tbltransactions (TransactionID, TransactionDate, PaymentMethod, CashTendered, CustomerID)
SELECT trans_id, date_time, payment_method, cash_tendered, customer_id FROM shop_transactions

Posted 28-Sep-11 0:25am

Mehdi Gholam

Comments

Reiss 28-Sep-11 5:31am

I was going to suggest what happens when just the select is executed, but I believe that this will resolve the issue

Mehdi Gholam 28-Sep-11 5:40am

Cheers

Prerak Patel · Accepted Answer · 2011-09-28T00:27:00

Solution 2

Try removing brackets.

SQL

INSERT INTO tbltransactions (TransactionID, TransactionDate, PaymentMethod, CashTendered, CustomerID)
SELECT trans_id, date_time, payment_method, cash_tendered, customer_id FROM shop_transactions

Posted 28-Sep-11 0:27am

Prerak Patel

ManavGuru · Accepted Answer · 2011-09-28T00:31:00

Solution 4

Insert Into tableName1 (column1 (datatype),column2(datatype)) values(select column1, column2 from tableanme2)

Posted 28-Sep-11 0:31am

ManavGuru

Getting data from one table and transferring it to another

4 solutions

Solution 1

Solution 2

Solution 4

Solution 3

Add your solution here

Preview 0

Getting data from one table and transferring it to another

4 solutions

Solution 1

Solution 2

Solution 4

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us