RSS
Follow Us
Contribute
 
 
 
 

ERROR 1064 (42000): You have an error in your SQL syntax

 
We need YOUR SKILLS in this collaborative work, to build the largest solution center for error messages.

From $1

Table of contents
  1. 1. Error Message
  2. 2. Cause
  3. 3. Solution

Error Message

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that correspons to your MySQL server version for the right syntax to use near (X) at line (X).

Cause

This may be the most common error message of MySQL server. Generally it is caused by a miswritten SQL command or syntax error.

Solution

Check your SQL syntax as it is told in the error mesage. If you can't still find the problem check the line that has been told in the error message and look at your SQl commands if they are valid. Since this is a common error message for all SQL sytax errors. There can be no appropriate general solution.

Tags:
 
 
 
 
Comments