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.
This is super handy for swapping out an active table with a clean version. For example, we log to article_clicks, but roll it off each day to article_clicks_YYYYMMDD and create a new clean article_clicks. We use RENAME TABLE for this to make it all atomic and not get and errors. I would hate to lose that feature in Drizzle.
Brian. _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
