MySQL Forums
Forum List  »  Oracle

oracle schema vs sql schema
Posted by: Shahzad Qureshi
Date: May 17, 2008 10:52AM

Hi there,

I wanted to find out if i can create multiple schemas in mysql as i can in Oracle.

for example: in Oracle i can create a database called "MYDB" and within mydb database i can create many schemas like "myclientschema1" and "myclientschema2". Then i can access a table called "table1" in any of the schema as MYDB.myclientschema1.table1. The reason for this is because the schema for every client is slightly different from one another.

Or DO i just create a separate "database" in mysql for every client and i would access table as myclientschema1.table1

Any help will be appreciated.

thank you

Options: ReplyQuote


Subject
Views
Written By
Posted
oracle schema vs sql schema
5963
May 17, 2008 10:52AM


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.