search

Home >Database >Mysql Tutorial >mysql select语句执行顺序_MySQL

mysql select语句执行顺序_MySQL

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
2016-06-01 13:47:12906browse

bitsCN.com

SELECT语句定义
      一个完成的SELECT语句包含可选的几个子句。SELECT语句的定义如下：

SELECT语句执行顺序
      SELECT语句中子句的执行顺序与SELECT语句中子句的输入顺序是不一样的，所以并不是从SELECT子句开始执行的，而是按照下面的顺序执行：
      开始->FROM子句->WHERE子句->GROUP BY子句->HAVING子句->ORDER BY子句->SELECT子句->LIMIT子句->最终结果
      每个子句执行后都会产生一个中间结果，供接下来的子句使用，如果不存在某个子句，就跳过

bitsCN.com
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：mysql_connect报告”No such file or directory”错误的解决方法_MySQLNext article：安装配置mysql主从环境_MySQL

Related articles

See more