, 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-
>
say you have 100 records.
you delete number 36.
your db will then be
...
34
35
37
38
...
correct?
after a delete, you could then say:
update table set id_num=id_num-1 where id > 36
and this would update all relevant records
-Original Message-
From: Thomas Edison Jr. [mailto:[EMAIL PROTEC
2 matches
Mail list logo
