But instead I end up with the following:
001 user1
003 user3
Any idea or comment?
The auto incrementing feature of mysql unfortunately will always increase by
1 based on the (MAX) primary key ID number. Questions about this have been
made to the MySQL development team as to if they would m
MAIL PROTECTED]>
>Date: Wednesday, July 04, 2001 11:45 PM
>Subject: [PHP-DB] Authomatic Sorting
>
>
> >Hello guys
> >
> >I have the following two problems:
> >
> >I've got a table with an autoincrement field which is the registry's ID,
HI,
Look into Optimizing the Table..
it seems to clean up the holes.
Ken
- Original Message -
From: "Wilmar Pérez" <[EMAIL PROTECTED]>
To: "PHP List" <[EMAIL PROTECTED]>
Sent: Wednesday, July 04, 2001 1:50 PM
Subject: [PHP-DB] Authomatic Sorting
>
ill help
Dobromir Velev
-Original Message-
From: Wilmar Pérez <[EMAIL PROTECTED]>
To: PHP List <[EMAIL PROTECTED]>
Date: Wednesday, July 04, 2001 11:45 PM
Subject: [PHP-DB] Authomatic Sorting
>Hello guys
>
>I have the following two problems:
>
>I've got a ta
ilto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 04, 2001 10:50 PM
> To: PHP List
> Subject: [PHP-DB] Authomatic Sorting
>
>
> Hello guys
>
> I have the following two problems:
>
> I've got a table with an autoincrement field which is the registry's ID,
>
D you ever create an index on the primary key to speed things up??
ken
- Original Message -
From: "Paul Burney" <[EMAIL PROTECTED]>
To: "Wilmar Pérez" <[EMAIL PROTECTED]>; "PHP List"
<[EMAIL PROTECTED]>
Sent: Wednesday, July 04, 2001 3:18 PM
on 7/4/01 1:50 PM, Wilmar Pérez at [EMAIL PROTECTED] wrote:
> I've got a table with an autoincrement field which is the registry's ID,
> everything goes well until I delete any registry. MySQL doesn't re-sorts
> the information. That is, I have the following:
Just add an "ORDER BY" clause to
Hello guys
I have the following two problems:
I've got a table with an autoincrement field which is the registry's ID,
everything goes well until I delete any registry. MySQL doesn't re-sorts
the information. That is, I have the following:
001 user1
002 user2
003 user3
If I delete user2,
