insert row into remote server

[Fernández Verdú]

how can i do inserts into remote database in mysql from command,or create link or ,stored procedure



For example in oracle create a database link.

Create database link mylink connect to user identified by pwd using 'connection string'

once defined this

i can insert to remote server using this link example.

insert into emple select * from emp@Mylink where deptno=20;