Software Venture Consulting
ToMarket

FileMaker Pro downloads & Resources
FileMaker Custom Functions
FileMaker Web Viewer Examples
FileMaker Pro & Lasso Consulting
Training
FileMaker Books
FileMaker Articles
FileMaker Error Reference

Free Web Tools
Free FileMaker Tools

Personal Pages
Videos
Adventures
Links

Shopping Cart
Shopping Cart

Search:

Free Newsletter
Signup


Contact


Privacy Policy



FileMaker is a registered trademark of FileMaker, Inc. in the U.S. and other countries.

 

 Reference: MySQL Error 1064

MySQL Error 1064 : SQLSTATE: 42000 (ER_PARSE_ERROR) %s near '%s' at line %d

FileMaker Error Codes

Lasso Error Codes

MySQL Error Codes

Windows System Errors


About this database
This is a free public resource. It is unmoderated and operates on the "public virtue" system. I hope you find it useful!

User Contributed Notes

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

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

2014-03-04 23:30:30
Sagar

SQL Error: 1064, SQLState: 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 ')' at line 1

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

+ Add your own note