Well, my comment on this is that the autoincrement field is giving you a 
primary key which is not changing, and this is good. Check the scripts you 
used to build the tables, and your MySQL docs for the MyISAM table type.

When tables are defined as being of the type MyISAM, the autoincrement 
numbers don't change. In the newer versions of MySQL that may be the 
default and you will have to add tell MySQL to NOT use this table type.

I don't know why you want to do this, as an unchanging, and really 
simple-to-implement primary key is a very useful feature, particularly as 
you can any sort order you desire in your SELECT statement.

Regards - Miles Thompson

At 10:10 AM 7/5/01 +0300, Dobromir Velev wrote:
>When you delete a record it doesn't affect the other ones, so if you want to
>change the other ones you have to update them too.
>For this purpose I use the following SQL command after deleting a row:
>
>UPDATE table SET id_field=id_field-1 where id_field>deleted_ID_value
>
>
>I hope this will 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 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, I would like to have something as shown next:
> >
> >001  user1
> >002  user3
> >
> >But instead I end up with the following:
> >
> >001  user1
> >003  user3
> >
> >Any idea or comment?
> >-----------------------------------------------
> >                Wilmar Pérez
> >     IT Manager - Central Library
> >         University of Antioquia
> >           Medellín - Colombia
> >          tel: ++57(4)2105145
> >-----------------------------------------------
> >
> >
> >--
> >PHP Database Mailing List (http://www.php.net/)
> >To unsubscribe, e-mail: [EMAIL PROTECTED]
> >For additional commands, e-mail: [EMAIL PROTECTED]
> >To contact the list administrators, e-mail: [EMAIL PROTECTED]
> >
> >
>
>
>--
>PHP Database Mailing List (http://www.php.net/)
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to