MySQL Error: 1064 SQLSTATE: 42000

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).

Satya Prakash

VOIP Expert: More than 8 years of experience in Asterisk Development and Call Center operation Management. Unique Combination of Skill Set as IT, Analytics and operation management.

Leave a Reply