MySQL Forums
Forum List  »  Oracle

Re: "ORACLE Schema" in MySQL
Posted by: Rick James
Date: January 31, 2009 02:03AM

MySQL supports multiple "databases". Each database can contain multiple "tables".

SELECT ... FROM db1.table1 JOIN db2.table2 ON ...;
Is quite valid, but rarely used. Generally, everything you want to use is in one database, and you say simply
USE my_db;
SELECT ... FROM table_a JOIN table_b ON ...;

Options: ReplyQuote


Subject
Views
Written By
Posted
4769
January 30, 2009 03:29AM
2868
January 30, 2009 04:55PM
Re: "ORACLE Schema" in MySQL
2872
January 31, 2009 02:03AM
2776
February 05, 2009 03:11AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.