Maybe If I get you in the right way, the answer for your second question is
you can use SQLYog or similar tools and can use them as a front end.
http://www.webyog.com/
regards
KS
----- Original Message -----
From: "Ayyaparaju Ganapathiraju" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 19, 2003 10:30 AM
Subject: How to create a schema
> 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
>
---------------------------------------------------------------------
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
