On Friday, September 27, 2002, at 07:57 AM, Jorge Martinez wrote:

>  Exists any way to rename a database ?
>
>  Thanks Jorge
>
> sql

You can create a new database and then:

Rename Table old_database.table_name to new_database.table_name.

You would have to do this for every table.  You could then drop the old 
database.
--
Clayburn W. Juniel, III -- Effective Software Solutions
Phone: (602) 326-7707    Mobile: (602)326-7707
Email: [EMAIL PROTECTED]
http://EffectiveSoftwareSolutions.com
--


---------------------------------------------------------------------
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

Reply via email to