Reference: MySQL Error 1064

SURVEY: Which web technology do you prefer?

View the results

ChartMaker Pro 7

Charts and graphs in your FileMaker 5/6/7/8 solution without a plug-in. Click here.

2005-11-07 10:47:12
Brian Dunning

It's a syntax error. You typed something wrong. Sometimes it can be frustrating as hell to find a tiny typo. Check the documentation for a clean example of your type of query.

This is my note and I want to edit it | Report an inappropriate comment

2010-02-26 17:13:43
Enrique Espinosa espinosaquique@hotmail.com

Hi, i have a problem with the next code:
$cons ="INSERT INTO visit(cub,dat,name) values ($cubi,$date,$nam);";
$rs = mysql_query($cons);

I´m trying to fill a data base whit this variables, but it is only giving me this line:
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 ')' at line 1
with this error 1064.
my code is correct, even it works with another html.
what can i do?

This is my note and I want to edit it | Report an inappropriate comment

2010-07-01 23:22:19
derya

I think it should be :
$cons ="INSERT INTO visit(cub,dat,name) values ($cubi,$date,$nam)";

; is the problem your code.

This is my note and I want to edit it | Report an inappropriate comment

2010-07-01 23:25:59
derya

I have just learned that while we constructing our data base,most of data type is array like VARCHAR(45) but if one of them is like VARCHAR,it gives this error also..

This is my note and I want to edit it | Report an inappropriate comment

2012-11-24 19:27:51
iram

Error code 1064, SQL state 42000: 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 '-papers .dmatched LIMIT 20 OFFSET 0' at line 1

bt my query is correct


1 select * from 'ranked-papers'.dmatched
2 select * from `ranked-papers`.dmatched

SQL nevery show error on query 2 bt it show error on query 1 bt both queryes are same bt what difference is btween these 2

plz help me

This is my note and I want to edit it | Report an inappropriate comment

2013-03-21 13:54:56
nn

Hello..
I have a problem with this code

DELETE FROM USERS_TABLE WHERE username='bob';--'

thank you

This is my note and I want to edit it | Report an inappropriate comment