renumber index/key field?

[Wm]

I just imported a CSV file into mySQL using PHPmyAdmin. With deletions,
etc., the numbering is now very "intermitte nt" on the key field. Is there a
way for me to delete all existing autonum key values and renumber them
sequentially?

Thanx,
Wm

[David]

Re: renumber index/key field?

Make sure the key field in mySQL is set as AutoNumber then when u import from your CSV dont import the key field mySQL
will create sequential autonum key values to fill in the gap.


"Wm" <LAshooter@hotm ail.com> wrote in message news:3c0Za.1557 153$Ho4.1089084 9@news.easynews .com...[color=blue]
> I just imported a CSV file into mySQL using PHPmyAdmin. With deletions,
> etc., the numbering is now very "intermitte nt" on the key field. Is there a
> way for me to delete all existing autonum key values and renumber them
> sequentially?
>
> Thanx,
> Wm
>
>
>[/color]