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
