On Wed, 27 Aug 2003 10:04:02 -0400
Paul DuBois <[EMAIL PROTECTED]> wrote:
> Second reason still applies.
yes, but I suppose he knows what he's trying to do =)
> If it's still something deemed desireable:
>
> ALTER TABLE tbl_name AUTO_INCREMENT = 1;
yes, this is another one possible solution, bu
At 17:56 +0400 8/27/03, Antony Dovgal wrote:
On Wed, 27 Aug 2003 09:38:16 -0400
Paul DuBois <[EMAIL PROTECTED]> wrote:
At 9:05 -0300 8/27/03, bernardaum wrote:
>Hi,
>
>I have a table with an auto_increment field. When I
>delete all the record and insert a new one the
>auto_increment field is
On Wed, 27 Aug 2003 09:38:16 -0400
Paul DuBois <[EMAIL PROTECTED]> wrote:
> At 9:05 -0300 8/27/03, bernardaum wrote:
> >Hi,
> >
> >I have a table with an auto_increment field. When I
> >delete all the record and insert a new one the
> >auto_increment field is not clean, its follows the
> >sequence
At 9:05 -0300 8/27/03, bernardaum wrote:
Hi,
I have a table with an auto_increment field. When I
delete all the record and insert a new one the
auto_increment field is not clean, its follows the
sequence.
Can I restart this sequence? Start from 0 again?
Why bother? MySQL doesn't care if there are
On Wed, 27 Aug 2003 13:27:25 +0100
Simon <[EMAIL PROTECTED]> wrote:
> On Wednesday 27 August 2003 1:05 pm, bernardaum wrote:
> > Hi,
> >
> > I have a table with an auto_increment field. When I
> > delete all the record and insert a new one the
> > auto_increment field is not clean, its follows the
On Wednesday 27 August 2003 1:05 pm, bernardaum wrote:
> Hi,
>
> I have a table with an auto_increment field. When I
> delete all the record and insert a new one the
> auto_increment field is not clean, its follows the
> sequence.
>
> Can I restart this sequence? Start from 0 again?
When I need to
On Wed, 27 Aug 2003 09:05:17 -0300
"bernardaum" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I have a table with an auto_increment field. When I
> delete all the record and insert a new one the
> auto_increment field is not clean, its follows the
> sequence.
>
> Can I restart this sequence? Start fro
At 14:17 -0700 4/15/02, Tani Hosokawa wrote:
>If you have a table with an auto_increment column and one of the rows
>has the value set to 0, doing an ALTER TABLE will change that value to
>either 2147483647 or the next auto_increment value.
Storing anything other than positive integers in an AUTO
