Re: Mass mySQL update...
| From: | John Nichel | Date: | Fri, 17 Dec 2004 17:29:33 +0000 |
| Subject: | Re: Mass mySQL update... | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-204607@lists.php.net to get a copy of this message | ||
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? Russhttp://lists.mysql.com/ -- John C. Nichel ÜberGeek KegWorks.com 716.856.9675 john@kegworks.com