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 ...;
Subject
Views
Written By
Posted
4989
January 30, 2009 03:29AM
2989
January 30, 2009 04:55PM
Re: "ORACLE Schema" in MySQL
2984
January 31, 2009 02:03AM
2883
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.