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
