On 12/12/08 12:42 PM, Monty Taylor wrote:
With rename table I can do:
rename table t1 to oldt1, t2 to oldt2, newt1 to t1, newt2 to t2;
Yes, we use this to rotate logging tables. Sure, there could be a
failure and one rename happen and the other doesn't, but it has yet to
happen. (crosses fingers)
To do it with ALTER, we would have to lock all tables, not just the ones
needing renaming.
--
Brian Moon
Senior Web Engineer
------------------------------
When you care enough to spend the very least.
http://dealnews.com/
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
