Re-number the AUTO_INCREMENT value

I'm sure I've seen a solution to this in the list somewhere but I'm not
able to find it.

I'd like to renumber my AUTO_INCREMENT field in one of my tables. Yes, I
know, it shouldn't matter what that value is, but I'd still like to do
it. Anyone recall how this can be done?
--
Amer Neely
Home of Spam Catcher
W: www.softouch.on.ca
E: trudge@softouch.on.ca
Perl | MySQL | CGI programming for all data entry forms.
"We make web sites work!"

Amer Neely wrote:
> I'm sure I've seen a solution to this in the list somewhere but I'm not
> able to find it.
>
> I'd like to renumber my AUTO_INCREMENT field in one of my tables. Yes, I
> know, it shouldn't matter what that value is, but I'd still like to do
> it. Anyone recall how this can be done?

Figured it out.

create table custid select po,custid from po_custid;

alter table custid add ID int unsigned not null auto_increment primary key;

drop table po_custid;

alter table custid rename as po_custid;

--
Amer Neely
Home of Spam Catcher
W: www.softouch.on.ca
E: trudge@softouch.on.ca
Perl | MySQL | CGI programming for all data entry forms.
"We make web sites work!"