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:
&g
Jason Pruim wrote:
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 field i
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 it
d.
> >
> >
> > 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?
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 based
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 is
he column, no error message 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
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
> databas
> 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 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?
Hop
10 matches
Mail list logo