This week's book giveaway is in the JavaFX forum.
We're giving away four copies of Introducing JavaFX 8 Programming and have Herbert Schildt on-line!
See this thread for details.
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

Win a copy of Introducing JavaFX 8 Programming this week in the JavaFX forum!
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: 3748

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!