>>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.
>
>Thanks ! but syntax error.....
Syntax error on what?
--sb--