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. -Sheeri On 12/12/08, Brian Aker <[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 > 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] > 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
