data migration query

Question

I have searched many questions and ready many different articles about this but no one seems to help me out or may be I could not able to understand completely. I want to migrate data from one database to another database.
This is my query

$query = mysql_query("
    Insert into database2.table2 (id, data)
    select (id, name) from database1.table1
");
if($query == false){   
    die(mysql_error());   
}

When I execute this query it shows me this error message which is really annoying Operand should contain 1 column(s)

I searched about it but found nothing which could help me.

Note: This query is initally for my test case. Actual query will be made later.

score 1 · Accepted Answer · edited May 25 '19 at 14:44

1

Try this query (Removing parenthesis from select fields),

INSERT into database2.table2 (id, data) SELECT id, name from database1.table1

Note: Please, don't use mysql_* functions in new code. They are no longer maintained and are officially deprecated. See the red box? Learn about prepared statements instead, and use PDO, or MySQLi - this article will help you decide which. If you choose PDO, here is a good tutorial.

edited May 25 '19 at 14:44

Zoe

27,060
21
118
148

answered Apr 15 '13 at 10:18

Rikesh

26,156
14
79
87

Ohh! Thanks Rikesh, I didn't notice that I am using brackets with SELECT. – Husnain Ahmed Apr 15 '13 at 10:24
@HoNeY - Glad to help you. Please don't forget to accept my answer by clicking the checkmark to the left of it. – Rikesh Apr 15 '13 at 10:25
What if the data is too large? Can this query handle large database too? – Husnain Ahmed Apr 15 '13 at 10:38
this is the best answer, better than mine, because it has links to PDO tutorials :) – STT LCU Apr 15 '13 at 11:06

score 0 · Answer 2 · answered Apr 15 '13 at 10:18

0

remove the parenthesis from

select (id, name)

to

select id, name

final result:

$query = mysql_query("Insert into database2.table2 (id, data) select id, name from database1.table1");

answered Apr 15 '13 at 10:18

STT LCU

4,348
4
29
47

Really appreciating your answer. Thanks but I have ticked one more question that will this query slow down my pc if the data is large? – Husnain Ahmed Apr 15 '13 at 10:42

data migration query

2 Answers2