want to select data from one server and insert on another.

For programming and general questions on Zend Framework
Post Reply
xeco5180
Posts: 1
Joined: Wed Oct 30, 2013 9:42 am

want to select data from one server and insert on another.

Post by xeco5180 » Wed Oct 30, 2013 10:01 am

I want to select records to customer table from global server and insert them into customer table of local server

I tried

$custlocalsql = $this->protectedLocalDB->exec("insert into tkglobal.customer ".$this->protectedDB->exec("select * from customer where id IN (176866,89789)"));

$this->protectedDB - Refers object to global server database
$this->protectedLocalDB - Refers object to local server database

i am getting below error
Message: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '0' at line 1

Post Reply