[Cialug] phpmysql ?

[Dave J. Hala Jr.]

Drop the column and recreate it.

ALTER mytable DROP id;
ALTER table mytable ADD id INT PRIMARY KEY AUTO_INCREMENT NOT NULL;

I can't remember if the numbering will start over at one or where it
last left off...



On Mon, 2005-02-14 at 13:46, albus wrote:
> Is there no way to reindex the id column in phpmysql for a mysql database 
> table?
> 
> I've tried about every thing to reindex them.
> 
> Next step, delete the table and redo it in a text editor. There has to be a 
> better way.
> 
> Joel 
> 
> 
> _______________________________________________
> Cialug mailing list
> Cialug@cialug.org
> http://cialug.org/mailman/listinfo/cialug
-- 

Open Source Information Systems (OSIS)
Dave J. Hala Jr. <dave@osis.us>
641.485.1606