mysql select from one server insert to another mysql server?

I wont to do ins开发者_如何学运维ert to one mysqll server to and get the data or do the select part

of the insert into select from anther mysql server

not just copy entire tables is this possible in my sql

I know that in MS Sql server you can do a linked server

thanks

The excellent, FOSS, cross-platform SQL Workbench query tool supports exactly this, for any database you have a JDBC driver for, as documented in this manual page.