How to create linked server MySQL

by

MySQL’s FEDERATED engine provides functionality similar to SQL Server’s Linked Server (and Oracle’s dblink) functionality, but doesn’t support connecting to vendors other than MySQL. It’s not clear from the question if you need the functionality to connect to vendors other than MySQL.

You might want to look into MySQL Proxy. This doesn’t match the architecture of Linked Servers/dblink, but you can probably solve a similar set of problems that you would use Linked Servers/dblink to solve.

More Related Contents:

  1. how to get result form mysql query in specific ids [closed]
  2. mysql error cant fix the error [duplicate]
  3. Why can’t this entry be added because of Foreign Key error?
  4. MySQL pivot row into dynamic number of columns
  5. How should I resolve –secure-file-priv in MySQL?
  6. node-mysql multiple statements in one query
  7. MySQL server startup error ‘The server quit without updating PID file’
  8. Select last row in MySQL
  9. MySQL AUTO_INCREMENT does not ROLLBACK
  10. Best type of indexing when there is LIKE clause [duplicate]
  11. MySQL LOAD DATA INFILE with ON DUPLICATE KEY UPDATE
  12. Difference between Key, Primary Key, Unique Key and Index in MySQL
  13. What’s the difference between MyISAM and InnoDB? [duplicate]
  14. Create new user in MySQL and give it full access to one database
  15. Are dynamic mysql queries with sql escaping just as secure as prepared statements?
  16. MySQL automatically cast/convert a string to a number?
  17. How to select rows that have current day’s timestamp?
  18. What’s the best database structure to keep multilingual data? [duplicate]
  19. LEFT JOIN only first row
  20. MySQL said: Documentation #1045 – Access denied for user ‘root’@’localhost’ (using password: NO)
  21. Using an IF Statement in a MySQL SELECT query
  22. How to hack MySQL GROUP_CONCAT to fetch a limited number of rows?
  23. MySQL connection over SSH tunnel – how to specify other MySQL server?
  24. Storing IPv6 Addresses in MySQL
  25. Insert/ Update random date in MySQL
  26. How to determine which database is selected
  27. How to remove constraints from my MySQL table?
  28. Get total hours worked in a day mysql
  29. Count duplicates records in Mysql table?
  30. Errno 121, duplicate key on write or update?

Leave a Comment