Solved

SQL Parsing algorithm

Posted on 2002-03-06
6
747 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
Comment Utility
The book "lexx & yacc" (O'Reilly Press) has the complete code for an SQL parser.
0
 

Author Comment

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

Expert Comment

by:ct.smith
Comment Utility
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
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
LVL 19

Expert Comment

by:Kim Ryan
Comment Utility
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
Comment Utility
0
 

Author Comment

by:avr555
Comment Utility
Sorry, I Need more theory about this.
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

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…
Displaying an arrayList in a listView using the default adapter is rarely the best solution. To get full control of your display data, and to be able to refresh it after editing, requires the use of a custom adapter.
An introduction to basic programming syntax in Java by creating a simple program. Viewers can follow the tutorial as they create their first class in Java. Definitions and explanations about each element are given to help prepare viewers for future …
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…

772 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now