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.