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?
avr555Asked:
Who is Participating?
 
Kim RyanConnect With a Mentor IT ConsultantCommented:
0
 
ct.smithCommented:
The book "lexx & yacc" (O'Reilly Press) has the complete code for an SQL parser.
0
 
avr555Author Commented:
Have you ane URL to find this book in electronical view?
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
ct.smithCommented:
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.
0
 
Kim RyanIT ConsultantCommented:
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
0
 
avr555Author Commented:
Sorry, I Need more theory about this.
0
All Courses

From novice to tech pro — start learning today.