how to generate a mysql query from a english question #1

Reply

Join Date: Mar 2008
Posts: 7
Reputation: krish_kooll is an unknown quantity at this point 
Solved Threads: 0
krish_kooll krish_kooll is offline Offline
Newbie Poster

how to generate a mysql query from a english question #1

 
0
  #1
Mar 27th, 2008
i want to generate a query
example:
if the english question s given

->list all the details from my_table where name='smith' and age <30

it shld generate a mysql query for the question

->SELECT * FROM my_table WHERE name = 'Smith AND age < 30;

using java as language
Reply With Quote Quick reply to this message  
Join Date: Nov 2004
Posts: 6,143
Reputation: jwenting is just really nice jwenting is just really nice jwenting is just really nice jwenting is just really nice 
Solved Threads: 213
Team Colleague
jwenting's Avatar
jwenting jwenting is offline Offline
duckman

Re: how to generate a mysql query from a english question #1

 
0
  #2
Mar 27th, 2008
you need to write a language parser that handles that translation for you.
It can be done, but if you didn't know that you needed to do it it's highly doubtful you have the skills to pull it off.
As people are clearly allowed to attack me but I'm not allowed to defend myself, I no longer post to this site.
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC