> I have a table, with 4 columns. One of the column is
> ID, a Primary Key, which has Auto_Increment set on it.
>
>
> Now i have a lot of rows deleted and a lot of
> duplicate rows that will be deleted, and all sorts of
> stuff happening in the table.. the result is, that the
> IDs have become i
> What i want to do is delete the entire IDs and
> generate them again so that they are in one single
> order like 1,2,3,4,5... .like this.
I suspect that if your table, as you use it, needs this ordering then
you've got something wrong. It really shouldn't matter much what the
internal IDs
Glory!
I have a table, with 4 columns. One of the column is
ID, a Primary Key, which has Auto_Increment set on it.
Now i have a lot of rows deleted and a lot of
duplicate rows that will be deleted, and all sorts of
stuff happening in the table.. the result is, that the
IDs have become inconsist
, but from the place you deleted on higher
> you need to decrement the
> id values by one.
>
> try this from the mysql command line on a test table
> with some fake records,
> and you should see what i mean...
>
> good luck
> jack
>
> -Original Message-
>
AIL PROTECTED]]
Sent: Monday, November 12, 2001 1:52 AM
To: [EMAIL PROTECTED]
Subject: [PHP] Resetting ID in mySQL DB
Hi,
I'm facing a problem. I made a simple DB with simple
adding records in DB operation. I've even put up a
JavaScript validation of the Form from where you add
info. An
Hi,
I'm facing a problem. I made a simple DB with simple
adding records in DB operation. I've even put up a
JavaScript validation of the Form from where you add
info. And yet, in the display table, there are many
many blank fields. I don't know how they are
generated.
The Adding of info form is
6 matches
Mail list logo