Yes, that atomicity is important in some applications. Jeremy
On Wed, Nov 25, 2009 at 12:20 PM, 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". > > _______________________________________________ > 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
