With rename table I can do: rename table t1 to oldt1, t2 to oldt2, newt1 to t1, newt2 to t2;
Or as an atomic command. I've done this for swapping data collection tables. It's a great workaround for not having transactional DDL. Very useful. Monty Brian Aker wrote: > Hi! > > RENAME TABLE and ALTER TABLE (for RENAME) have different execution > paths/etc. Is there a specific reason for RENAME TABLE? > > Cheers, > -Brian > > > > -- > _______________________________________________________ > Brian "Krow" Aker, brian at tangent.org > Seattle, Washington > http://krow.net/ <-- Me > http://tangent.org/ <-- Software > _______________________________________________________ > You can't grep a dead tree. > > > > > _______________________________________________ > Mailing list: https://launchpad.net/~drizzle-discuss > Post to : [email protected] > Unsubscribe : https://launchpad.net/~drizzle-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
