I noticed once when executing a SQL query the following error:
#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
To solve it, you must carefully review the sql query for errors, such as missing or incorrect quotes or the absence of a semicolon at the end of the line, to make sure that the syntax is correct.
This is the main solution to the error.
By the way, there are websites on the Internet with online syntax checking, you just insert the request and click the check button.