Tell me more ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 0 down vote favorite

I want to write a php function that could parse select SQL queries.

Just for an example:

select * from tableA a, tableB b
where a.cola = b.colb
and cola = 'abcd'

to convert into:

select * from tableA a where a.cola = 'abcd'
select * from tableB b where b.colb = 'abcd'

It should also work on inner joins.

Any help regarding the approach / algorithm or Code would help??

*I am using http://code.google.com/p/php-sql-parser/ to perform this.

UPDATE: What I am really looking for is to make sure that we had all the data, but not a lot of extra data was to split each query into a single table select, and covert that select into an insert. That would insure that the original query could run, and have all the data it needs. I need to make sure all data is in the correct tables to recreate that page execution with a new database.

share|improve this question
1  
What have you tried so far using php-sql-parser – Ø Hanky Panky Ø Mar 28 at 5:13
I could able to parse the query extract all parameters from it. But I am stuck at logic part. How to handle all test-cases and also for the Inner Joins – djadmin Mar 28 at 5:15
offtopic: what you want to achieve? – sectus Mar 28 at 5:16
1  
Your example does not tell us what you're trying to do, so we cannot help you do it. Furthermore, your example IS an inner join. Unless you completely control the input of the parser, I'd recommend hiring someone to do it. Parsing variable inputs you don't control is really difficult and very involved. For instance, there are many different ways of writing the same query and you'd have to account for all of them. There's also no guarantee that your input is a valid query which is a whole other bucket of worms. – starshine531 Mar 28 at 8:53

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.