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 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 of records and don't want the ID's to keep piling up. Thanks, Will ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278030 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
