aspose file tools
The moose likes JDBC and the fly likes mysql select exception Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


JavaRanch » Java Forums » Databases » JDBC
Reply 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: 3666
    
    2

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
 
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: mysql select exception
 
Similar Threads
what wrong with 1=1 ?
MySQL error
Can't execute prepared statements using mySQL
someone please help me out with this thing
Newbie's question for Hibernate+MySQL