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 Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
