Is it possible to query across two connections in MySql? Or is there a MSSQL "linked server" equivalent?
My goal is this is pseudo code:
SELECT * FROM prd_connection.schema.t_table
INTO dev_connection.schema.t_table_dev
-
That question is about using PHP and the answer is about 2 databases, not two connections.Warren– Warren2018-01-09 22:37:24 +00:00Commented Jan 9, 2018 at 22:37
-
Check out dev.mysql.com/doc/refman/5.5/en/federated-storage-engine.html. Not sure if this is what you need but might help.clinomaniac– clinomaniac2018-01-09 22:48:08 +00:00Commented Jan 9, 2018 at 22:48
Add a comment
|