It's not a secret anymore!*
The moose likes JDBC 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
Bookmark "mysql select exception" Watch "mysql select exception" New topic
Author

mysql select exception

srinus reddyy
Greenhorn

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
Rancher

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: 3704
    
    5

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'


My Blog: Down Home Country Coding with Scott Selikoff
 
wood burning stoves
 
subject: mysql select exception