40

MySQL内核源码解读-SQL解析之解析器浅析-王伟

 5 years ago
source link: http://blog.51cto.com/wangwei007/2300959
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
MYSQL服务器接收SQL格式的查询,首先要对sql进行解析,内部将文本格式转换为二进制结构,这个转换就是解析器,解析的目的是为了让优化器更好的处理指令,以便以最优的路径,最少的耗时返回我们想要的结果。sql解析器的构成:1、词法分析(Lexicalscanner):作用是将整个查询分解为多个元素。2、语法规则(Grammarrulemodule):寻找sql语法规则组合,产生一个序列,执行这些规

About Joyk


Aggregate valuable and interesting links.
Joyk means Joy of geeK