>Hi all !
>how to insert mysql local table from remote table ?
>SQLEXEC(lnHandle,"insert into LocalTable.employee select * from RemoteTable.employee")
Not sure about MySQL, but in SQL Server the full name of the table is:
[Server].[DataBase].[Schema].[TableName]
So maybe in MySQL is the same:
SQLEXEC(lnHandle,"insert into LocalServer.DataBase.Schema.employee select * from RemoteServer.DataBase.Schema.employee")
But you should check for the right syntax.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.