如何在mysql中创建连接,如何在MySQL中创建数据库链接以连接到Oracle？

I need to create a database link in MySQL to connect to an Oracle database to use a table present in the Oracle database.

I am not able to find any code or method of creating a database link in MySQL. How could I do this?

解决方案

You can access the Oracle (or other DBMS) information directly from within MySQL using the MySQL Federated tables via the Perl DBIx::MyServer proxy. This method has been around since about 2007: a good step-by-step write-up of the set-up and usage is available here:

http://ftp.nchu.edu.tw/MySQL/tech-resources/articles/dbixmyserver.html

The write-up demonstrates not only the usage of 'select' statements from directly within MySQL to postgres and sqlite native tables, but also inserts back into those tables, using queries executed directly from within the MySQL environment.

The Perl module is available here: http://search.cpan.org/~philips/DBIx-MyServer-0.42/lib/DBIx/MyServer.pm

Good luck!