hi,
May be this is not the right forum for the following question regarding mysql but if one can check it out for me it is great.
I am using mysql and
JDBC for some application that uses the jakarta
struts frame work.
mysql works fine with a lot of insert, delete, and what not but when i am trying to update I get some error which has already costed me many hours. Here is some details that might help you help me in detecting this problem.
the sql statement:
The
Java code:
the SQL:
upon execution i get the following error:
Syntax error or access violation, message from server:
"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 'where student_id = "xxxxxxxx".
where "xxxxxxxx" is a wrong value for student_id. What syntax error in mysql could be causing this?
Thank you, in advance, for trying to help.
Lee