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

Definition of 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

digg this | del.icio.us this

SURVEY: Which web technology do you prefer?

PHP         Cold Fusion
JSP         J2EE
ASP/.Net         Other
Lasso          

View the results


Progress Bars

Add progress bars to those slow scripts in your FileMaker Pro solution. Click here.

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

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

 

 

Click here for PHP/MySQL consulting services