Link to home
Start Free TrialLog in
Avatar of avr555
avr555

asked on

SQL Parsing algorithm

Now I try create some SQL builder.
And for this I need Paresing SQL statements and for this I need some algorithm.

Can anybody help me?
Avatar of ct.smith
ct.smith

The book "lexx & yacc" (O'Reilly Press) has the complete code for an SQL parser.
Avatar of avr555

ASKER

Have you ane URL to find this book in electronical view?
No, but its not all that expensive and relatively easy to find at bookstores.  It's also been around a while, so there's a chance that you may be able to borrowa copy from a library, friend, coworker, etc.
Of course the publisher will not give away their contents for free. But they do supply program code. Download http://examples.oreilly.com/lex/progs.zip and study sql1.y, sql2.y and sqltext.c

There is also a Perl based SQL parser at http://www.cpan.org/modules/by-module/SQL/SQL-Statement-1.003.tar.gz
ASKER CERTIFIED SOLUTION
Avatar of Kim Ryan
Kim Ryan
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of avr555

ASKER

Sorry, I Need more theory about this.