标签

Cygwin 2

apt-cyg 1

GoFlexHome 2

NAS 2

Shell 7

RaspberryPi 1

speedometer 1

Dnspod 1

DDNS 1

transmission 2

screen 1

tree 1

SVN 1

Ubuntu 2

xrdp 1

LXDE 1

Redmine 1

Ruby 1

rvm 2

Android 3

阿里云 1

MySQL 3

Finder 1

MacOSX 8

代理 1

域名 1

Quicklook 1

ping 1

Linux 1

TCP/IP 1

Chrome 1

iPhone 1

fish 3

shell 1

Java 2

HotSpot 1

Firefox 1

Windows 1

JVM 1

Vagrant 1

Alfred 1

Homebrew 1

SQL 1

漏洞 1

科学上网 1

Shadowsocks 1

iOS 1

Trac 1

Python 2

sshd 1

jenv 1

HTTP 1

iptables 1


SQL查询语句执行顺序

2015年04月28日

[目录]

感觉很重要，为什么看了那么多讲解MySQL的书都没有提到？记录下来。

(7)     SELECT 
(8)     DISTINCT <select_list>
(1)     FROM <left_table>
(3)     <join_type> JOIN <right_table>
(2)     ON <join_condition>
(4)     WHERE <where_condition>
(5)     GROUP BY <group_by_list>
(6)     HAVING <having_condition>
(9)    ORDER BY <order_by_condition>
(10)    LIMIT <limit_number>
//