Quote:
Originally posted by Armed & Hammered
why would the primary key matter?
UPDATE TABLE SET column='value' WHERE column='value'
|
If any of the other rows happen to have the same value, it'll change them too with this statement.
JC if you're not coding something and you just want to fiddle with a table, try downloading PHPMyAdmin.
It's free and it's really easy to use. Google for it.
It will lay out the database like a spreadsheet so it's easy to look at, and you can directly edit the values for whichever row you want (just click the 'edit' link at the end of that particular row).