Re: [PHP] Mass mySQL update...

if you don't mind it being an int - try something like... ALTER TABLE table ADD ID INT NOT NULL INTEGER UNIQUE AUTO_INCREMENT, ADD PRIMARY KEY (ID); Reference: http://dev.mysql.com/doc/mysql/en/ALTER_TABLE.html Respectfully, Ligaya Turmelle --- Life is a game... so have fun. --- www.PHPComm

Re: [PHP] Mass mySQL update...

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

Re: [PHP] 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

[PHP] Mass mySQL update...

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 ma