File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
JDBC and Relational Databases
mysql select exception
Joined: Jul 04, 2007
Jun 09, 2008 06:10:00
from boomerang_alumni_registration where BAR_status="current";
i am getting the below exception while executing the query
please let me know what's wrong with the query
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 '"curr' at line 2
Joined: Mar 06, 2001
Jun 09, 2008 07:43:00
use single quotes around strings in SQL, not double quotes
Joined: Oct 23, 2005
Jun 09, 2008 12:36:00
And a reminder use two single quotes (not the double quotes character) to include an actual single quote within the text of the query. Such as: SELECT * FROM widgets WHERE name = 'O''brian'
[OCA 8 Book]
I agree. Here's the link:
subject: mysql select exception
Newbie's question for Hibernate+MySQL
Can't execute prepared statements using mySQL
what wrong with 1=1 ?
someone please help me out with this thing
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015