Re: Mass mySQL update...

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Russell P Jones wrote:
So I populated a mySQL database but forgot to create random ids for each
record.

I have used phpmyadmin to add a varchar(15) column named "id" at the end
of the database for each record, but now am wondering if there is an easy
way to get random ID's into each of these...

The column values for many of the entries are not unique, so I couldnt
just loop through saying where term = $row[term] set id= rand(1, 99999)

any other ideas? Any way to refer to a particular row without matching
values?

Russ


http://lists.mysql.com/

--
John C. Nichel
ÜberGeek
KegWorks.com
716.856.9675
john@xxxxxxxxxxxx

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux