PDA

View Full Version : update all rows via sql


sabret00the
07-06-2004, 08:55 PM
stupid question but how do i update all rows via phpmyadmin to set a value in one of the columns?

Andreas
07-06-2004, 08:58 PM
update table set column = value;


Of course you must replace table, column and value with the real names/value :)

sabret00the
07-07-2004, 12:36 PM
thanks kirby, was so basic :(