Sheeri K. Cabral wrote:
> Personally, I use ALTER TABLE for everything I can . . . I don't use
> CREATE INDEX, DROP INDEX, RENAME TABLE, etc.  Maybe for SQL standard
> compliance?
> 
> But since we're here.....One "alternative" syntax I would like to see in
> Drizzle (since it was almost in MySQL 5.1 but then taken out!) would be
> RENAME DATABASE.  I've done this quite easily by doing:
> 
> CREATE DATABASE new_db;
> 
> and then generating the following statement:
> 
> ALTER TABLE old_db.tbl RENAME new_db.tbl;
> 
> for *every* *single* table.  It'd be much nicer if the DB just did that.

Related to what I was writing earlier, it would be great if there was a:

ROTATE DATABASE;

or similar, that would do a combination of what Sheeri is talking about
above and what I was talking about all as one atomic thing.

> -Sheeri
> 
> On 12/12/08, *Brian Aker* <[email protected] <mailto:[email protected]>>
> wrote:
> 
>     Hi!
> 
>     RENAME TABLE and ALTER TABLE (for RENAME) have different execution
>     paths/etc. Is there a specific reason for RENAME TABLE?
> 
>     Cheers,
>            -Brian
> 
> 
> 
>     --
>     _______________________________________________________
>     Brian "Krow" Aker, brian at tangent.org <http://tangent.org>
>     Seattle, Washington
>     http://krow.net/                     <-- Me
>     http://tangent.org/                <-- Software
>     _______________________________________________________
>     You can't grep a dead tree.
> 
> 
> 
> 
>     _______________________________________________
>     Mailing list: https://launchpad.net/~drizzle-discuss
>     <https://launchpad.net/%7Edrizzle-discuss>
>     Post to     : [email protected]
>     <mailto:[email protected]>
>     Unsubscribe : https://launchpad.net/~drizzle-discuss
>     <https://launchpad.net/%7Edrizzle-discuss>
>     More help   : https://help.launchpad.net/ListHelp
> 
> 
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Mailing list: https://launchpad.net/~drizzle-discuss
> Post to     : [email protected]
> Unsubscribe : https://launchpad.net/~drizzle-discuss
> More help   : https://help.launchpad.net/ListHelp


_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to     : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help   : https://help.launchpad.net/ListHelp

Reply via email to