Newbie - End of Statement error

[SmokeyJoe]

I am trying to update a MySQL database. The update syntax is shown below.



UPDATE [LOW_PRIORITY] [IGNORE] tbl_name
SET col_name1=expr1 [, col_name2=expr2, ...]
[WHERE where_definition]

It would appear that a command such as:

Update Generic SET LName = "Jones"
or
Update Generic Set City = "New York" Where GenericID = RecID

should work. However, I get an "Expected End of Statement" Error. How do I correct this type of error?

Thanks in Advance

SmokeyJoe

 

[snowboardr]

When you have a field that isnt numeric such as an auto id you need to put single quotes around it.

Update Generic Set City = "'New York'" Where GenericID = RecID

www.vzio.com
ASP WEB DEVELOPMENT