No option to TRUNCATE TABLE ?

General usage of Access to MySQL

Moderator: jr

No option to TRUNCATE TABLE ?

Postby jlig » 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
jlig
 
Posts: 1
Joined: Mon Nov 07, 2011 5:23 pm

Re: No option to TRUNCATE TABLE ?

Postby chloewright » Sat Oct 20, 2012 3:41 pm

Seems there's no way you can do this way.
chloewright
 
Posts: 1
Joined: Sat Oct 20, 2012 3:15 pm


Return to General

Who is online

Users browsing this forum: No registered users and 1 guest

cron