MySQL and Oracle JDeveloper

2003-02-22 Thread Ayyaparaju Ganapathiraju
Hi, This is actually a question for Oracle JDeveloper forums, but I couldn't get any replies from that forum. If you are using JDeveloper on MySQL database, please help me with this question. Since MySQL doesn't have any equivalent to schema or user as in Oracle, I am creating tables in

Re: How to create a schema

2003-02-19 Thread Ayyaparaju Ganapathiraju
Thank you very much. That information is very helpful as I am just starting to use/learn MySQL. Raju Ganapathiraju From: Roger Baklund [EMAIL PROTECTED] To: [EMAIL PROTECTED] CC: Ayyaparaju Ganapathiraju [EMAIL PROTECTED] Subject: Re: How to create a schema Date: Wed, 19 Feb 2003 13:32:32

How to create a schema

2003-02-18 Thread Ayyaparaju Ganapathiraju
Hi, I have two questions here, please. 1). Is there an equivalent to creating a schema in MySQL. I would like to create tables in multiple schemas within the same database. Some of the tables will have foregign keys across schemas. I'm aware that I can create multiple databases and switch