Solved

SQL Parsing algorithm

Posted on 2002-03-06
6
765 Views
Last Modified: 2012-06-21
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?
0
Comment
Question by:avr555
  • 2
  • 2
  • 2
6 Comments
 
LVL 4

Expert Comment

by:ct.smith
ID: 6844754
The book "lexx & yacc" (O'Reilly Press) has the complete code for an SQL parser.
0
 

Author Comment

by:avr555
ID: 6847182
Have you ane URL to find this book in electronical view?
0
 
LVL 4

Expert Comment

by:ct.smith
ID: 6848086
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
Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 19

Expert Comment

by:Kim Ryan
ID: 6851715
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
 
LVL 19

Accepted Solution

by:
Kim Ryan earned 100 total points
ID: 6855868
0
 

Author Comment

by:avr555
ID: 6856820
Sorry, I Need more theory about this.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Go is an acronym of golang, is a programming language developed Google in 2007. Go is a new language that is mostly in the C family, with significant input from Pascal/Modula/Oberon family. Hence Go arisen as low-level language with fast compilation…
Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question