I dont understand the error
Isn’t that the right syntax?
No…
UPDATE assets set col=value, col=value WHERE...
Notice that there is no “TABLE” in the actual statement. Where you see “TABLE” is where you are suppose to put the table name.
please allow me to introduce you to da manual – it answers all questions like this
in this specific case, the syntax for UPDATE
This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.