Guys, how to copy View records from REMOTE SQL Server 2005 to a Table on LOCAL mySQL using PHP?
from the View (REMOTE SQL Server 2005) : select * from source_View开发者_如何学C
Fields : username, firstname, lastname, email, nikinto (local mySQL) : select * from target_table
Fields : username, firstname, lastname, email, idnumberPlease help, thank you..
This will not work as you cannot have an SQL statement that processes records from two different hosts in one go. Why don't you just get sql dump of the table and import it using MySQL.
精彩评论