Join tables from two different server

by

Yes, it is possible in MySQL.

There are similar questions asked previously too. You have to use FEDERATED ENGINE to do this. The idea goes like this:

You have to have a federated table based on the table at another remote location to use the way you want. The structure of the table have to exactly same.

CREATE TABLE federated_table (
    id     INT(20) NOT NULL AUTO_INCREMENT,
    name   VARCHAR(32) NOT NULL DEFAULT '',
    other  INT(20) NOT NULL DEFAULT '0',
    PRIMARY KEY  (id),
    INDEX name (name),
    INDEX other_key (other)
)
ENGINE=FEDERATED
DEFAULT CHARSET=latin1
CONNECTION='mysql://fed_user@remote_host:9306/federated/test_table';

[Source Answer]

More Related Contents:

  1. how to delete data from table A besides the customer service and director data in table B?
  2. Get records with max value for each group of grouped SQL results
  3. How to store multiple options in a single table?
  4. How to populate a table with a range of dates?
  5. Get the new record primary key ID from MySQL insert query?
  6. brew install mysql on macOS
  7. TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT maximum storage sizes
  8. MySQL pagination without double-querying?
  9. MySQL convert date string to Unix timestamp
  10. How to speed up SELECT .. LIKE queries in MySQL on multiple columns?
  11. Using an Alias in SQL Calculations
  12. MySql Table Insert if not exist otherwise update
  13. How to get difference between two dates in months using MySQL query?
  14. MySQL – Control which row is returned by a group by
  15. Can MySQL replace multiple characters?
  16. Docker (Apple Silicon/M1 Preview) MySQL “no matching manifest for linux/arm64/v8 in the manifest list entries”
  17. My MySQL trigger doesn’t work, simple syntax, not complicated
  18. Using ORDER BY and GROUP BY together
  19. How can VBA connect to MySQL database in Excel?
  20. updating columns with a sequence number mysql
  21. Select a column with a keyword name
  22. Sum results of a few queries and then find top 5 in SQL
  23. Select all months within given date span, including the ones with 0 values
  24. ERROR 1356 (HY000): View ‘mysql.user’ references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
  25. Use Composite Primary Key as Foreign Key
  26. Equivalent of MSSQL IDENTITY Column in MySQL
  27. #1060 – Duplicate column name ‘id’
  28. Update multiple rows with multiple ‘where’ clauses for each individual row
  29. WHERE datetime older than some time (eg. 15 minutes)
  30. Is there a way to use ON DUPLICATE KEY to Update all that I wanted to insert?

Leave a Comment