Fixing ID's in mySQL Table
| From: | Rahul S. Johari | Date: | Tue, 08 Nov 2005 13:37:14 +0000 |
| Subject: | Fixing ID's in mySQL Table | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-225283@lists.php.net to get a copy of this message | ||
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. ID¹ 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