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

For programming and general questions on Zend Framework

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

Postby xeco5180 on 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
xeco5180
 
Posts: 1
Joined: Wed Oct 30, 2013 9:42 am

Return to Zend Framework

Who is online

Users browsing this forum: No registered users and 4 guests