No option to TRUNCATE TABLE ?
Posted: Mon Nov 07, 2011 5:36 pm
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
- 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