Error: 1064 SQLSTATE: 42000 (ER_PARSE_ERROR)
Message: %s near ‘%s’ at line %d
Error #1064 means that MySQL can’t understand your command. To fix it:
- Read the error message. It tells you exactly where in your command MySQL got confused.
- Check the manual. By comparing against what MySQL expected at that point, the problem is often obvious.
- Check for reserved words. If the error occurred on an object identifier, check that it isn’t a reserved word (and, if it is, ensure that it’s properly quoted).