For example 2 DBases:
- DBMS Postgresql
- DBMS MySQL
In each DB include one DB and one table in it. Can I work with table in PostgreSQL through MySQL?
Is it possible to link as federated postgresql table to mysql database? For make insert/update/select/delete or join operations with such linked table.
I can link MySQL to MySQL by code below and make all operations.
CREATE TABLE `f_t21` ( `id` int(11) DEFAULT NULL, `name` varchar(255) DEFAULT NULL ) ENGINE=FEDERATED DEFAULT CHARSET=latin1 CONNECTION='mysql://user:firstname.lastname@example.org:3306/db/table'
Can I link postgresql table of anyone postgresql version to someone mysql version? for it using as part of federated DB?