Is there away to reset an auto incrementing field count? I have a
database that currently has 935 records in it but because I have
deleted a few the current number used for NEW records is 938 :) How
can I get it to count the records and assign a record number based on
the total count?
is not changed.
Ed
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 29, 2007 11:02 AM
To: Jason Pruim
Cc: MySQL List
Subject: Re: Reset a auto increment field?
Is there away to reset an auto incrementing field count? I have a
database
is
given and the current sequence value is not changed.
Ed
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 29, 2007 11:02 AM
To: Jason Pruim
Cc: MySQL List
Subject: Re: Reset a auto increment field?
Is there away to reset an auto incrementing field
Yes, for a MyIsam type table.
Ed
-Original Message-
From: Jason Pruim [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 29, 2007 11:53 AM
To: emierzwa
Cc: [EMAIL PROTECTED]; mysql@lists.mysql.com
Subject: Re: Reset a auto increment field?
If I understand you correctly, if my table
Hi Jason,
Jason Pruim wrote:
Is there away to reset an auto incrementing field count? I have a
database that currently has 935 records in it but because I have deleted
a few the current number used for NEW records is 938 :) How can I get it
to count the records and assign a record number
www.the-infoshop.com
www.giiexpress.com
www.etudes-marche.com
-Original Message-
From: Jason Pruim [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 29, 2007 1:53 PM
To: [EMAIL PROTECTED]@micron.com
Cc: [EMAIL PROTECTED]; mysql@lists.mysql.com
Subject: Re: Reset a auto increment field
On Aug 29, 2007, at 2:30 PM, Shawn Green wrote:
Hi Jason,
Jason Pruim wrote:
Is there away to reset an auto incrementing field count? I have a
database that currently has 935 records in it but because I have
deleted a few the current number used for NEW records is 938 :)
How can I get
Jason Pruim wrote:
snip
I see what you are getting at with this, and have decided that mucking
around with auto incrementing values doesn't exactly fit in with the way
databases were designed to work.
Somehow though, I still need to supply this whether I end up adding a
Record number
www.etudes-marche.com
-Original Message-
From: Jason Pruim [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 29, 2007 3:16 PM
To: Shawn Green
Cc: MySQL List
Subject: Re: Reset a auto increment field?
On Aug 29, 2007, at 2:30 PM, Shawn Green wrote:
Hi Jason,
Jason Pruim wrote