Re: MySQL - need auto increment back to 0...

I believe Navicat also has a similar feature although I haven't used Navicat much. Found it in Navicat! It's under the design table options tab Thanks a ton! Will ~| Create robust enterprise, web RIAs. Upgrade

Re: MySQL - need auto increment back to 0...

And without a GUI cheers, barneyb HA HA HA HA HA Barney! Me? Without a GUI? Sorry, that just struck me as hilarious. :) Will ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see

RE: MySQL - need auto increment back to 0...

Deleting records does not reset the counter. Truncating the table will though. -Original Message- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: Sunday, May 13, 2007 8:23 AM To: CF-Talk Subject: OT: MySQL - need auto increment back to 0... Did some googlin' on this and didnt

OT: MySQL - need auto increment back to 0...

Did some googlin' on this and didnt come up with much. I have an auto increment ID in a MySQL table. Let's say 10,000 are inserted. Then you delete those 10,000. You add another and the auto increment sets the id at 10001. How can I get that table to start back to 0? I'm testing with a lot

Re: OT: MySQL - need auto increment back to 0...

Sent: Sun May 13 14:22:57 2007 Subject: OT: MySQL - need auto increment back to 0... Did some googlin' on this and didnt come up with much. I have an auto increment ID in a MySQL table. Let's say 10,000 are inserted. Then you delete those 10,000. You add another and the auto increment sets

Re: MySQL - need auto increment back to 0...

In the past I have just deleted the column and recreated it, which effectively sets the autoincrement back to 0. However there are definitely a few downfalls of this approach (broken relationships and not straightforward when done programatically) - I'll be interested in finding if anyone has a

Re: MySQL - need auto increment back to 0...

Thanks Neil! I ended up finding TRUNCATE TABLE with your search. Seemed to do the trick. :) Will ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial

Re: MySQL - need auto increment back to 0...

Will Tomlinson said the following on 5/13/2007 9:11 AM: Thanks Neil! I ended up finding TRUNCATE TABLE with your search. Seemed to do the trick. In addition to what others have said, some of the MySQL GUI programs will let you reset the autoincrement numbering fairly easily. For example, I

Re: MySQL - need auto increment back to 0...

And without a GUI (such as via CFQUERY), you can use a simple ALTER TABLE statement. Check http://dev.mysql.com/doc/refman/5.0/en/example-auto-increment.html for specifics. cheers, barneyb On 5/13/07, Chris Montgomery [EMAIL PROTECTED] wrote: Will Tomlinson said the following on 5/13/2007 9:11