Posted by "Rahul S. Johari" on 10/20/05 11:31

Ave,

This is what I need to do.
Let's say, my ID's in a table look like this:

1
7
9
11
12
19
26
27
29
30

I need to alter the table so that the ID's are in a sequence like this:

1
2
3
4
5
6
7
8
9
10

It's easy to manually do this if you have a table with 10 records, but you
can't do it manually in a table with 5000 records.

I know that I can DELETE the ID Column and recreate it and that will Fix
this problem, but doing that over and over with all the tables isn't what
I'm really looking for. I just feel there should be a way in PHP to execute
a logical query to do this. If not of course I can do the delete/recreate
using phpmyadmin, but I just want to see if there's a php script way to do
it.

Thanks.



On 11/8/05 9:22 AM, "Gustav Wiberg" <gustav@varupiraten.se> wrote:

> Hi there!
>
> Do you want an orderby-statement to be done on ID-field? Is that what you
> mean?
> I would go to phpmyadmin and fix that in the database-structure. (or some
> kind of database-utility)
>
> /G
> http://www.varupiraten.se/



> ----- Original Message -----
> From: "Rahul S. Johari" <rjohari@nycap.rr.com>
> To: "PHP" <php-general@lists.php.net>
> Sent: Tuesday, November 08, 2005 2:37 PM
> Subject: [PHP] Fixing ID's in mySQL Table
>
>
>
> Ave,
>
> Is there a way to fix ID sequence in a MySQL table using PHP?
> Basically I have some tables with a lot of records, 1000 to 5000. OID¹ is
> the Primary Key column in these tables, and at the time the code was
> originally written, there weren¹t much verification of data being input
> going on. Thus a lot of junk records were being let in, which had to be
> deleted at some point or another. Now the ID sequence is all screwed up.
> It¹s not in sequence anymore.
>
> Is there a way to fix this?
>
> Thanks,
>
> Rahul S. Johari
> Coordinator, Internet & Administration
> Informed Marketing Services Inc.
> 251 River Street
> Troy, NY 12180
>
> Tel: (518) 266-0909 x154
> Fax: (518) 266-0909
>
>
> Email: rahul@informed-sources.com
> http://www.informed-sources.com

[Back to original message]