How to create a schema

[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 between databases using "use <database name>".

2). How can I edit a statement within mysql. Suppose if I make a typo in a large select statement, can I go into an editor and fix it, then execute it from the buffer.

Any suggestions.

Raju Ganapathiraju



_________________________________________________________________
Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963


---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php