1、简单检索数据
SELECT-DISTINCT-LIMIT 1-LIMIT 0,1-LIMIT 1 OFFSET 0
以products表为例:
mysql> select vend_id from products;
mysql> select DISTINCT vend_id from products;
mysql> select DISTINCT vend_id from products limit 1; #显示最前面1行
mysql> select DISTINCT vend_id from products limit 0,1; #从第0行开始,一共1行
mysql> select DISTINCT vend_id from products limit 1 offset 0; # 一共1行,从第0行开始,
2、排序
ORDER BY-field1 DESC, field2
3、简单过滤数据
尽量在MYSQL完成过滤,给应用程序和网络传输减少压力……
SELECT-WHERE-AND-OR(基本WHERE语句+组合WHERE语句)
其中,用于WHERE条件的描述符:
- = ‘FUSE’
- != 1003
- <>1003
- BETWEEN 1 AND 5
- IS NULL
- IN
- NOT(NOT可以否定的有:NOT IN ,NOT BETWEEN,NOT EXISTS)
IN是枚举,虽然可以用一长串OR替代,但是IN执行更快,且最大优点是可以包含其他SELECT语句
(待续,争取每天30页+)