On Wed, May 20, 2009 at 10:59 AM, dealmaker <vin...@gmail.com> wrote:
> > Your second option is similar to what I had in my original post, following > are my mysql commands: > BEGIN; > RENAME TABLE my_table TO backup_table; > CREATE TABLE my_table LIKE backup_table; > COMMIT; > FYI, the "BEGIN" and "COMMIT" there are useless. MySQL does not have transactional DDL - as soon as you execute that "RENAME" it actually commits your current transaction. -Todd
