Add an auto_increment column of an appropriate int size.
Jaime Teng wrote:
> Hi,
>
> Is there a "number sequence" generator/function in
> MySQL such that if I were to execute:
> "UPDATE mytable SET id = thisfunction;"
> it will update the table mytable and set the column
> id to a numbered sequence "1,2,3,4,5,6,7,8,9....."?
>
> currently, i have a table with 2.5 million records and
> i want to change one of the field and sequence it and
> am doing it the hard way of updating one at a time.
>
> regards
> Jaime
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
><[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Gerald L. Clark
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php