Page 1 of 1

No option to TRUNCATE TABLE ?

Posted: Mon Nov 07, 2011 5:36 pm
by jlig
Maybe I have missed this.. but wondering if there is a way to just "delete" all of the data in a MySQL table before transferring?
- I only see the option to "DROP and RECREATE destination database" and "Transfer Records"
- But no option to just "update my existing Table" without DROPPING the table?

- What would be best is an option to "TRUNCATE TABLE and Transfer records" because this would a) Not delete table, b) Start AutoNum back at "1", c)transfer new records

Note: DELETE FROM <tablename> does *not* reset the auto increment counter. It will remain as it was before the delete.
TRUNCATE <tablename> *does* reset the counter to 1

Any ideas on this?
Thanks,
jlig

Re: No option to TRUNCATE TABLE ?

Posted: Sat Oct 20, 2012 3:41 pm
by chloewright
Seems there's no way you can do this way.