SQL Error when saving

Need Help
1

Can anyone shed some light on why this error is happening? Is it because the column DESC is similar to a keyword for Descending in an order by?

Error: SQLSTATE[42000]: Syntax error or access violation: 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 ‘DESC = ‘test’ , modified = ‘2018-09-19 18:53:01’ WHERE id = 1266’ at line 1

2

https://dev.mysql.com/doc/refman/8.0/en/keywords.html

3

Yes that was the issue I just went ahead and changed DESC to DESCRIPTION and that fixed the issue.

4

if you encounter this “problem” more often remember that you can also escape table and column names with backticks. ex.:

SELECT * FROM table WHERE `DESC` = 'test'

https://dev.mysql.com/doc/refman/5.7/en/identifiers.html