File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes mysql select exception Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "mysql select exception" Watch "mysql select exception" New topic

mysql select exception

srinus reddyy

Joined: Jul 04, 2007
Posts: 6
select BAR_fname,BAR_lname,BAR_empid,BAR_userid,BAR_date_of_regn
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
David O'Meara

Joined: Mar 06, 2001
Posts: 13459

use single quotes around strings in SQL, not double quotes
Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3753

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] [Blog]
I agree. Here's the link:
subject: mysql select exception
It's not a secret anymore!