• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

MYSQL error

 
Hrishikesh Maluskar
Ranch Hand
Posts: 115
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
i am getting the following error.
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: 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 '@yahoo.com,1,1,77,77,0,1,77,77)' at line 1


my SQL is as follows->
 
Jan Cumps
Bartender
Posts: 2588
11
C++ Linux Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Your error is not coming from this statement. Can you post the exact code that caused the problem?
 
Scott Selikoff
author
Saloon Keeper
Posts: 4015
18
Eclipse IDE Flex Google Web Toolkit
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
This is the type of SQL error message that you should read carefully. Clearly, you have an error in the statement going to the server. Try turning on JDBC logging and outputting the exact SQL statement that goes to the MySQL server then run it inside of a SQL client tool. That should have you find out whats wrong with your SQL string.
 
Hrishikesh Maluskar
Ranch Hand
Posts: 115
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
my java code is as follows->

 
Campbell Ritchie
Sheriff
Pie
Posts: 49466
64
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I edited your post because the lines were too long. As well as something wrong with the syntax, I suspect your database design. I suspect you might have too many columns in that table; things like first name are not attributes of a flat so much as the landlord/landlady. The landlord and landlady merit a table of their own. The values you inserted in the first example you showed appear to be different from the names of the columns, which makes your problem more difficult to analyse.
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34686
367
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hrishikesh,
That SQL is missing the single quotes around the String fields. It should be


Note you really should be using a PreparedStatement rather than concatentating user values to prevent a SQL Injection attack.
 
Hrishikesh Maluskar
Ranch Hand
Posts: 115
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
very very thanks Jeanne , i wasted 2 days for this problem.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic