Jump to content

SQL ALTER command


HumbleApprentice
 Share

Recommended Posts

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';

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...