You can set up federated tables in MySQL to accomplish what you’re trying to do. There are some limitations.
http://dev.mysql.com/doc/refman/en/federated-storage-engine.html
http://dev.mysql.com/doc/refman/en/federated-usagenotes.html
More Related Contents:
- Bind address and MySQL server [closed]
- How to get maximum number of products matched vendors list. But i don't want to check same products again [closed]
- How to select the nth row in a SQL database table?
- MySQL – How to unpivot columns to rows?
- Alternative to Intersect in MySQL
- Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
- MySQL SELECT only not null values
- How to find all tables that have foreign keys that reference particular table.column and have values for those foreign keys?
- How can I use mySQL replace() to replace strings in multiple records?
- Detect if value is number in MySQL
- Difference between two dates in MySQL
- How to remove accents in MySQL?
- MySQL search and replace some text in a field
- Why is MySQL InnoDB insert so slow?
- Prevent auto increment on MySQL duplicate insert
- Group mysql query by 15 min intervals
- MySQL – force not to use cache for testing speed of query
- How do I know when my docker mysql container is up and mysql is ready for taking queries?
- MySQL FULL JOIN?
- How to fill in the “holes” in auto-increment fields?
- Using Count to find the number of occurrences
- Is there any reason to worry about the column order in a table?
- How to fix double-encoded UTF8 characters (in an utf-8 table)
- How to integrate ElasticSearch with MySQL?
- MYSQL select DISTINCT values in two columns
- MySQL Select ID’s which occur on different rows with multiple specific values for a column
- Use promise to process MySQL return value in node.js
- How can I achieve initcap functionality in MySQL?
- Disadvantages of quoting integers in a Mysql query?
- How do I add more members to my ENUM-type column in MySQL?