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 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 use SQLYog and have done this several times using the > Advanced Properties button under the Alter Table (F6) window. I believe > Navicat also has a similar feature although I haven't used Navicat much. > > -- > Best regards, > > Chris Montgomery > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277999 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
