Thread: Database Update script problems
View Single Post
  #6 (permalink)  
Old May 13th, 2007, 11:00
as22607 as22607 is offline
Junior Member
Join Date: May 2007
Location: britain
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Re: Database Update script problems
this is the sql error i am getting

ERROR: Unclosed quote @ 121STR: 'SQL: UPDATE 'student' SET studentname = 'test', class = 'test', math = '30', english = '40', socsci = '50', WHERE studentid = '1000SQL-query :
UPDATE 'student' SET studentname = 'test', class = 'test', math = '30', english = '40', socsci = '50', WHERE studentid = '1000
MySQL said:

#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 ''student' SET studentname = 'test', class = 'test', math = '30'
Reply With Quote