After discussed and explained the theory of the SQL complier implementation, this paper implements a SQL complier with comprehensive functions, using the LEX and YACC tools in UNIX.

• 先从理论上讨论和解释了SQL编译器的核心技术,然后在实现中采用Unix工具LEX和YACC实现了一个SQL编译器。