SQL ALTER command

[HumbleApprentice]

Hi can someone please tell me why I am getting an error message with this ALTER STATEMENT. I entered the wrong isbn number in my table and would like to change it. The version of mySQL that I am using is 5.5.20-log. Thanks. ALTER TABLE classics WHERE title ='Little Dorrit' CHANGE isbn = '9780141439969';

[niche]

Looks like you're changing the contents of the table not the table. Try UPDATE. http://www.w3schools.com/sql/sql_update.asp

[justsomeguy]

To help clarify, ALTER TABLE changes the structure of the table, UPDATE changes the data in the table.

[HumbleApprentice]

Hi Guys, I tried UPDATE but it does not work. Here is the error message: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TABLE classics WHERE title ='Little Dorrit' CHANGE isbn = '9780141439969'' at line 1 I get the same message when I use ALTER

[justsomeguy]

You don't use the words "table" or "change" in an update query, check some of the examples in the link above.

[HumbleApprentice]

Thanks Guys, Problem solved. The UPDATE STATEMENT fixed it. Here is the code: UPDATE classics SETisbn = '9780141439969'WHERE title = 'Little Dorrit' ;