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
>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
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 & inte
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:
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
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
http://www.adobe.com/products/
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
7 matches
Mail list logo