List:MySQL on Win32« Previous MessageNext Message »
From:Paul DuBois Date:December 10 2000 7:32pm
Subject:Re: How to sequence an existing column with v3.22
View as plain text  
At 10:20 AM -0500 12/10/00, Stephen Woodbridge wrote:
>Hi all,
>
>Can someone tell me how to (re)sequence a existing column with v3.22?

Use ALTER TABLE to drop it, then use ALTER TABLE to add it back.
MySQL will renumber the column.

But first ask yourself if you really need to. MySQL doesn't care if
values are sequential.

>Thanks,
>   -Steve
>
>---------------------------------------------------------------------
>Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
>posting. To request this thread, e-mail win32-thread4499@stripped
>
>To unsubscribe, send a message to the address shown in the
>List-Unsubscribe header of this message. If you cannot see it,
>e-mail win32-unsubscribe@stripped instead.


-- 
Paul DuBois, paul@stripped
Thread
How to sequence an existing column with v3.22Stephen Woodbridge10 Dec
  • Re: How to sequence an existing column with v3.22Paul DuBois10 Dec