Re: Mass mySQL update...

On Saturday 18 December 2004 00:39, Russell P Jones wrote: > 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... Why? What are these random ID's used for? > 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? UPDATE without a WHERE clause (or with WHERE 1) will update all rows. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * ------------------------------------------ Search the list archives before you post http://marc.theaimsgroup.com/?l=php-general ------------------------------------------ /* BOFH Excuse #308: CD-ROM server needs recalibration */