On Wed, Nov 25, 2009 at 15:20, Sheeri K. Cabral <[email protected]> wrote: > On Wed, Nov 25, 2009 at 3:14 PM, Brian Aker <[email protected]> wrote: >> Hi! >> >> I was just about to guy RENAME TABLE and then realized that it has one >> difference with ALTER TABLE... it doesn't do TEMPORARY TABLES. >> >> So if I change it, it now does temporary tables... which makes me wonder... >> >> Can this just go away? If someone really wants this they can write an alias >> in the client for it. > > > hrm....one thing about RENAME TABLE is that you can rename several > tables at once. (I believe it's even atomic). With ALTER TABLE, at > least in the current MySQL incarnation, you can only change one table > per statement. > > > - Sheeri K. Cabral > > http://tinyurl.com/mysqlbook will take you to the Amazon.com page for > my book, "MySQL Administrator's Bible". >
The nice thing about RENAME TABLE is that it is atomic, while ALTER TABLE is not. Ideally, I think it would be best to make ALTER TABLE fully ACID-compliant rather than an implicit commit. -- Darius Jahandarie _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
