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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277964 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4