Spring JDBC BadSqlGrammarException: MySQL Syntax Error in UPDATE Statement - How to Fix

The error message indicates that there is a syntax error in the SQL statement being executed. Specifically, the error is related to the use of the keyword "order" as a column name in the SQL statement. \n\nTo fix this issue, you can try enclosing the column name "order" in backticks () to make it a valid identifier in MySQL. For example:\n\n```sql\nUPDATE typecho_contents SET title=?, slug=?, created=?, modified=?, text=?, order`=?, authorId=?, template=?, type=?, commentsNum=?, allowComment=?, allowPing=?, allowFeed=?, parent=?, views=?, agree=? WHERE cid=?\n```\n\nBy using backticks, you can avoid conflicts with reserved keywords in MySQL.\n\nAdditionally, make sure that the values being passed as parameters in the SQL statement are correct and properly formatted.\n\nIf the issue persists, you may need to check the version of your MySQL server and ensure that it supports the syntax being used in the SQL statement.