MySQL question

[Anon]

Hi all,
I have a MySQL database with a table called bands. This has 4 fields: Band_ID, name, album and genre. Lets say i manually insert the following data:

INSERT INTO bands VALUES("0","Pink Floyd","The Wall","Rock");
INSERT INTO bands VALUES("0","David Bowie","Changes","Rock");

My question is can i manually change one field value without having to change all the values, if so what would the SQL be?

Cheers,
Michael

[Anon]

update tablename set somecolumn=somevalue where someothercolumn=someothervalue.

Why on earth are you inserting the value '0' for the band id? A sane design would make that an autoincrementing unique id, on which you could select in order to make the updates.

[Anon]

i'm just after the SQL....not a lecture

[Anon]

Then read the manual. The sql is there, minus the lecture.