索引

語言
查詢
- 基礎查詢
- - select 查詢串列 from 表名;
  - 查詢函式（呼叫函式，獲取回傳值）
  - 起別名
  - +的作用
  - distinct的使用（去重）
  - 查看表的結構
- 條件查詢
- - 按關系運算式篩選
  - 按邏輯運算式篩選
  - 模糊查詢
  - - like
    - in
    - between and
    - is null
- 排序查詢
- - - 按單個欄位排序
    - 按運算式排序
    - 按別名排序
    - 按函式的結果排序
    - 按多個欄位排序
    - 按列數排序

語言

DQL(data query language)（資料查詢語言）
SQL(s=select)（選擇查詢語言）
DML(data manipulation language)(資料操作語言）
DDL(data define language)(資料定義語言)
TCL(transaction control language)(事務控制語言)

查詢

基礎查詢

select 查詢串列 from 表名;

特點：查詢的結果集是一個虛擬表（列印內容）

select后面跟的查詢串列，可以有多個部分組成，中間用逗號隔開：select 欄位1,欄位2,運算式 from 表;

執行順序
① from子句
② select子句

查詢串列可以是：欄位、運算式、常量、函式等
USE myemployees;

一、查詢常量
SELECT 100 ;

二、查詢運算式
SELECT 100%3;

三、查詢單個欄位
SELECT last_name FROM employees;

四、查詢多個欄位
SELECT last_name,email,employee_id FROM employees;

五、查詢所有欄位
SELECT * FROM employees;

查詢函式（呼叫函式，獲取回傳值）

SELECT DATABASE();
SELECT VERSION();
SELECT USER();

起別名

方式一：使用as關鍵字
SELECT USER() AS 用戶名;
SELECT USER() AS “用戶名”;
SELECT USER() AS ‘用戶名’;

SELECT last_name AS “姓名” FROM employees;

方式二：使用空格
SELECT USER() 用戶名;
SELECT USER() “用戶名”;
SELECT USER() ‘用戶名’;

SELECT last_name “姓名” FROM employees;

mysql> select last_name as 'xing ming' from employees;
+-------------+
| xing ming   |
+-------------+
| K_ing       |
| Kochhar     |
| De Haan     |
| Hunold      |

+的作用

-需求：查詢 first_name 和last_name 拼接成的全名，最終起別名為：姓名

方案1：使用+ pass×
SELECT first_name+last_name AS “姓名”
FROM employees;

方案2：使用concat拼接函式
SELECT CONCAT(first_name,last_name) AS “姓名”
FROM employees;

mysql> select concat(first_name,last_name) as 'xing ming' from employees;
+------------------+
| xing ming        |
+------------------+
| StevenK_ing      |
| NeenaKochhar     |
| LexDe Haan       |
| AlexanderHunold  |
| BruceErnst       |
| DavidAustin      |
| ValliPataballa   |
| DianaLorentz     |
| NancyGreenberg   |

distinct的使用（去重）

mysql> select department_id from employees;  #有重復
+---------------+
| department_id |
+---------------+
|          NULL |
|            10 |
|            20 |
|            20 |
|            30 |
|            30 |
|            30 |
|            30 |
|            30 |
|            30 |

distinct adj. 明顯的；獨特的；清楚的；有區別的
查詢員工涉及到的部門編號有哪些
SELECT DISTINCT department_id FROM employees;

mysql> select distinct department_id from employees; #無重復
+---------------+
| department_id |
+---------------+
|          NULL |
|            10 |
|            20 |
|            30 |
|            40 |
|            50 |
|            60 |
|            70 |
|            80 |
|            90 |
|           100 |
|           110 |
+---------------+
12 rows in set (0.00 sec)

查看表的結構

DESC employees;

列 columns
SHOW COLUMNS FROM employees;

條件查詢

select 查詢串列
from 表名
where 篩選條件;

執行順序：
①from子句
②where子句
③select子句

select last_name,first_name from employees where salary>20000;

按關系運算式篩選

關系運算子：> < >= <= = <> (或 != )(不等于)

mysql> select *                          #要查的東西
    -> from employees                    #表名
    -> where department_id <> 100;       #條件
+-------------+-------------+-------------+----------+--------------------+------------+----------+----------------+------------+---------------+---------------------+
| employee_id | first_name  | last_name   | email    | phone_number       | job_id     | salary   | commission_pct | manager_id | department_id | hiredate            |
+-------------+-------------+-------------+----------+--------------------+------------+----------+----------------+------------+---------------+---------------------+
|         100 | Steven      | K_ing       | SKING    | 515.123.4567       | AD_PRES    | 24000.00 |           NULL |       NULL |            90 | 1992-04-03 00:00:00 |
|         101 | Neena       | Kochhar     | NKOCHHAR | 515.123.4568       | AD_VP      | 17000.00 |           NULL |        100 |            90 | 1992-04-03 00:00:00 |
|         102 | Lex         | De Haan     | LDEHAAN  | 515.123.4569       | AD_VP      | 17000.00 |           NULL |        100 |            90 | 1992-04-03 00:00:00 |
|         103 | Alexander   | Hunold      | AHUNOLD  | 590.423.4567       | IT_PROG    |  9000.00 |           NULL |        102 |            60 | 1992-04-03 00:00:00 |
|         104 | Bruce       | Ernst       | BERNST   | 590.423.4568       | IT_PROG    |  6000.00 |           NULL |        103 |            60 | 1992-04-03 00:00:00 |
|         105 | David       | Austin      | DAUSTIN  | 590.423.4569       | IT_PROG    |  4800.00 |           NULL |        103 |            60 | 1998-03-03 00:00:00 |
|         106 | Valli       | Pataballa   | VPATABAL | 590.423.4560       | IT_PROG    |  4800.00 |           NULL |        103 |            60 | 1998-03-03 00:00:00 |
|         107 | Diana       | Lorentz     | DLORENTZ | 590.423.5567       | IT_PROG    |  4200.00 |           NULL |        103 |            60 | 1998-03-03 00:00:00 |
|         114 | Den         | Raphaely    | DRAPHEAL | 515.127.4561       | PU_MAN     | 11000.00 |           NULL |        100 |            30 | 2000-09-09 00:00:00 |
|         115 | Alexander   | Khoo        | AKHOO    | 515.127.4562       | PU_CLERK   |  3100.00 |           NULL |        114 |            30 | 2000-09-09 00:00:00 |
|         116 | Shelli      | Baida       | SBAIDA   | 515.127.4563       | PU_CLERK   |  2900.00 |           NULL |        114 |            30 | 2000-09-09 00:00:00 |
|         117 | Sigal       | Tobias      | STOBIAS  | 515.127.4564       | PU_CLERK   |  2800.00 |           NULL |        114 |            30 | 2000-09-09 00:00:00 |
|         118 | Guy         | Himuro      | GHIMURO  | 515.127.4565       | PU_CLERK   |  2600.00 |           NULL |

案例2：查詢工資<15000的姓名、工資

mysql> select last_name,salary  #要查的東西
    -> from employees           #表名
    -> where salary<15000;      #篩選條件
+-------------+----------+
| last_name   | salary   |
+-------------+----------+
| Hunold      |  9000.00 |
| Ernst       |  6000.00 |
| Austin      |  4800.00 |

按邏輯運算式篩選

邏輯運算子：and or not 也可以使用&& || !

案例：查詢獎金率>0.03 或者員工編號在60-110之間的員工資訊

mysql> select *
    -> from employees
    -> where commission_pct >0.03 or(employee_id >=60 and employee_id<=110);
+-------------+-------------+------------+----------+--------------------+------------+----------+----------------+------------+---------------+---------------------+
| employee_id | first_name  | last_name  | email    | phone_number       | job_id     | salary   | commission_pct | manager_id | department_id | hiredate            |
+-------------+-------------+------------+----------+--------------------+------------+----------+----------------+------------+---------------+---------------------+
|         100 | Steven      | K_ing      | SKING    | 515.123.4567       | AD_PRES    | 24000.00 |           NULL |       NULL |            90 | 1992-04-03 00:00:00 |
|         101 | Neena       | Kochhar    | NKOCHHAR | 515.123.4568       | AD_VP      | 17000.00 |           NULL |        100 |            90 | 1992-04-03 00:00:00 |
|         102 | Lex         | De Haan    | LDEHAAN  | 515.123.4569       | AD_VP      | 17000.00 |           NULL |        100 |            90 | 1992-04-03 00:00:00 |
|         103 | Alexander

模糊查詢

like

功能：一般和通配符搭配使用，對字符型資料進行部分匹配查詢
常見的通配符：
_ 任意單個字符
% 任意多個字符,支持0-多個
like/not like

案例1：查詢姓名中包含字符a的員工資訊

mysql> select *
    -> from employees
    -> where last_name like '%a%';
+-------------+-------------+------------+----------+--------------------+------------+----------+----------------+------------+---------------+---------------------+
| employee_id | first_name  | last_name  | email    | phone_number       | job_id     | salary   | commission_pct | manager_id | department_id | hiredate            |
+-------------+-------------+------------+----------+--------------------+------------+----------+----------------+------------+---------------+---------------------+
|         101 | Neena       | Kochhar    | NKOCHHAR | 515.123.4568       | AD_VP      | 17000.00 |           NULL |        100 |            90 | 1992-04-03 00:00:00 |
|         102 | Lex         | De Haan    | LDEHAAN  | 515.123.4569       | AD_VP      | 17000.00 |           NULL |        100 |            90 | 1992-04-03 00:00:00 |
|         105 | David       | Austin     | DAUSTIN  | 590.423.4569       | IT_PROG    |  4800.00 |           NULL |        103 |

案例2：查詢姓名中包含第三個字符為x的員工資訊

mysql> select *
    -> from employees
    -> where last_name like '__x%';
+-------------+------------+-----------+-------+--------------------+--------+---------+----------------+------------+---------------+---------------------+
| employee_id | first_name | last_name | email | phone_number       | job_id | salary  | commission_pct | manager_id | department_id | hiredate            |
+-------------+------------+-----------+-------+--------------------+--------+---------+----------------+------------+---------------+---------------------+
|         170 | Tayler     | Fox       | TFOX  | 011.44.1343.729268 | SA_REP | 9600.00 |           0.20 |        148 |            80 | 2014-03-05 00:00:00 |
+-------------+------------+-----------+-------+--------------------+--------+---------+----------------+------------+---------------+---------------------+
1 row in set (0.00 sec)

案例3：查詢姓名中包含第二個字符為_的員工資訊

mysql> select *
    -> from employees
    -> where last_name like '_\_%';
+-------------+------------+-----------+-------+--------------------+---------+----------+----------------+------------+---------------+---------------------+
| employee_id | first_name | last_name | email | phone_number       | job_id  | salary   | commission_pct | manager_id | department_id | hiredate            |
+-------------+------------+-----------+-------+--------------------+---------+----------+----------------+------------+---------------+---------------------+
|         100 | Steven     | K_ing     | SKING | 515.123.4567       | AD_PRES | 24000.00 |           NULL |       NULL |            90 | 1992-04-03 00:00:00 |
|         156 | Janette    | K_ing     | JKING | 011.44.1345.429268 | SA_REP  | 10000.00 |           0.35 |        146 |            80 | 2014-03-05 00:00:00 |
+-------------+------------+-----------+-------+--------------------+---------+----------+----------------+------------+---------------+---------------------+
2 rows in set (0.00 sec)

SELECT *
FROM employees
WHERE last_name LIKE '_$_%' ESCAPE '$'; #將￥定義為轉義字符

escape
vt. 逃避，避開，避免；被忘掉；被忽視
vi. 逃脫；避開；溜走；

in

查詢某欄位的值是否屬于指定的串列之內
a in(常量值1,常量值2,常量值3,…)
a not in(常量值1,常量值2,常量值3,…)

in/not in

案例1：查詢部門編號是30/50/90的員工名、部門編號

#方式1：
SELECT last_name,department_id
FROM employees
WHERE department_id IN(30,50,90);

#方式2：

SELECT last_name,department_id
FROM employees
WHERE department_id = 30
OR department_id = 50
OR department_id = 90;

案例2：查詢工種編號不是SH_CLERK或IT_PROG的員工資訊

#方式1：
SELECT *
FROM employees
WHERE job_id NOT IN('SH_CLERK','IT_PROG');

#方式2：
SELECT *
FROM employees
WHERE NOT(job_id ='SH_CLERK'
OR job_id = 'IT_PROG');

mysql> select *
    -> from employees
    -> where not(job_id ='SH_CLERK'
    -> or job_id ='IT_PROG');
+-------------+-------------+-------------+----------+--------------------+------------+----------+----------------+------------+---------------+---------------------+
| employee_id | first_name  | last_name   | email    | phone_number       | job_id     | salary   | commission_pct | manager_id | department_id | hiredate            |
+-------------+-------------+-------------+----------+--------------------+------------+----------+----------------+------------+---------------+---------------------+
|         100 | Steven      | K_ing       | SKING    | 515.123.4567       | AD_PRES    | 24000.00 |           NULL |       NULL |            90 | 1992-04-03 00:00:00 |
|         101 | Neena       | Kochhar     | NKOCHHAR | 515.123.4568       | AD_VP      | 17000.00 |           NULL |        100 |            90 | 1992-04-03 00:00:00 |
|         10

between and

判斷某個欄位的值是否介于xx之間
between and/not between and

案例1：查詢部門編號是30-90之間的部門編號、員工姓名

#方式1：
SELECT department_id,last_name
FROM employees
WHERE department_id BETWEEN 30 AND 90;

#方式2：

SELECT department_id,last_name
FROM employees
WHERE department_id>=30 AND department_id<=90;

案例2：查詢年薪不是100000-200000之間的員工姓名、工資、年薪

SELECT last_name,salary,salary*12*(1+IFNULL(commission_pct,0)) 年薪
FROM employees
WHERE salary*12*(1+IFNULL(commission_pct,0))<100000 OR salary*12*(1+IFNULL(commission_pct,0))>200000;



SELECT last_name,salary,salary*12*(1+IFNULL(commission_pct,0)) 年薪
FROM employees
WHERE salary*12*(1+IFNULL(commission_pct,0)) NOT BETWEEN 100000 AND 200000;

mysql> SELECT last_name,salary,salary*12*(1+IFNULL(commission_pct,0))
    -> from employees
    -> WHERE salary*12*(1+IFNULL(commission_pct,0)) NOT BETWEEN 100000 AND 200000;
+-------------+----------+----------------------------------------+
| last_name   | salary   | salary*12*(1+IFNULL(commission_pct,0)) |
+-------------+----------+----------------------------------------+
| K_ing       | 24000.00 |                              288000.00 |
| Kochhar     | 17000.00 |                              204000.00 |
| De Haan     | 17000.00 |                              204000.00 |
| Ernst       |  6000.00 |                               72000.00 |
| Austin      |  4800.00 |                               57600.00 |

is null

案例1：查詢沒有獎金的員工資訊
SELECT *
FROM employees
WHERE commission_pct IS NULL;
案例2：查詢有獎金的員工資訊
SELECT *
FROM employees
WHERE commission_pct IS NOT NULL;

= 只能判斷普通的內容

IS 只能判斷NULL值

<=> 安全等于，既能判斷普通內容，又能判斷NULL值

SELECT *
FROM employees
WHERE salary <=> 10000;

SELECT *
FROM employees
WHERE commission_pct <=> NULL;

排序查詢

語法：
select 查詢串列
from 表名
【where 篩選條件】
order by 排序串列

順序：

from子句
where子句
select子句
order by 子句

(order
n. 命令；順序；規則；訂單；（生物學）目
vt. 命令；整理；訂購
vi. 命令；訂貨)
(order by 以…排序)

特點：

排序串列可以是單個欄位、多個欄位、運算式、函式、列數、以及以上的組合
升序，通過 asc ，默認行為
降序，通過 desc

（desc abbr. 降序排列（descend 的縮寫））

按單個欄位排序

將員工編號>120的員工資訊進行工資的升序

mysql> use myemployees;
Database changed
mysql> select *
    -> from employees
    -> order by salary;
+-------------+-------------+-------------+----------+--------------------+------------+----------+----------------+------------+---------------+---------------------+
| employee_id | first_name  | last_name   | email    | phone_number       | job_id     | salary   | commission_pct | manager_id | department_id | hiredate            |
+-------------+-------------+-------------+----------+--------------------+------------+----------+----------------+------------+---------------+---------------------+
|         132 | TJ          | Olson       | TJOLSON  | 650.124.8234       | ST_CLERK   |  2100.00 |           NULL |        121 |            50 | 2004-02-06 00:00:00 |
|         128 | Steven      | Markle      | SMARKLE  | 650.124.1434       | ST_CLERK   |  2200.00 |           NULL |        120 |            50 | 2004-02-06 00:00:00 |
|         136 | Hazel       | Philtanker  | HPHILTAN | 650.127.1634       | ST_CLERK   |  2200.00 |           NULL |        122 |            50 | 2002-12-23 00:00:00 |
|         127 | James       | Landry      | JLANDRY  | 650.124.1334       | ST_CLERK   |  2400.00 |           NULL |        120 |            50 | 2004-02-06 00:00:00 |
|         135 | Ki          | Gee         | KGEE     | 650.127.1734       | ST_CLERK   |  2400.00 |           NULL |        122 |            50 | 2002-12-23 00:00:00 |
|         119 | Karen       | Colmenares  | KCOLMENA | 515.127.4566       | PU_CLERK   |  2500.00 |           NULL |

將員工編號>200的員工資訊進行工資的降序

mysql> select*
    -> from employees
    -> where employee_id>200
    -> order by salary desc;
+-------------+------------+-----------+----------+--------------+------------+----------+----------------+------------+---------------+---------------------+
| employee_id | first_name | last_name | email    | phone_number | job_id     | salary   | commission_pct | manager_id | department_id | hiredate            |
+-------------+------------+-----------+----------+--------------+------------+----------+----------------+------------+---------------+---------------------+
|         201 | Michael    | Hartstein | MHARTSTE | 515.123.5555 | MK_MAN     | 13000.00 |           NULL |        100 |            20 | 2016-03-03 00:00:00 |
|         205 | Shelley    | Higgins   | SHIGGINS | 515.123.8080 | AC_MGR     | 12000.00 |           NULL |        101 |           110 | 2016-03-03 00:00:00 |
|         204 | Hermann    | Baer      | HBAER    | 515.123.8888 | PR_REP     | 10000.00 |           NULL |        101 |            70 | 2016-03-03 00:00:00 |
|         206 | William    | Gietz     | WGIETZ   | 515.123.8181 | AC_ACCOUNT |  8300.00 |           NULL |        205 |           110 | 2016-03-03 00:00:00 |
|         203 | Susan      | Mavris    | SMAVRIS  | 515.123.7777 | HR_REP     |  6500.00 |           NULL |        101 |            40 | 2016-03-03 00:00:00 |
|         202 | Pat        | Fay       | PFAY     | 603.123.6666 | MK_REP     |  6000.00 |           NULL |        201 |            20 | 2016-03-03 00:00:00 |
+-------------+------------+-----------+----------+--------------+------------+----------+----------------+------------+---------------+---------------------+
6 rows in set (0.00 sec)

按運算式排序

對有獎金的員工，按年薪降序

IFNULL() 函式用于判斷第一個運算式是否為 NULL，如果為 NULL 則回傳第二個引數的值，如果不為 NULL 則回傳第一個引數的值，

IFNULL() 函式語法格式為： IFNULL(expression, alt_value)

mysql> select *,salary*12*(1+ifnull(commission_pct,0))
    -> from employees
    -> where commission_pct is not null
    -> order by salary*12*(1+ifnull(commission_pct,0))desc;
+-------------+-------------+------------+----------+--------------------+--------+----------+----------------+------------+---------------+---------------------+----------------------------------------+
| employee_id | first_name  | last_name  | email    | phone_number       | job_id | salary   | commission_pct | manager_id | department_id | hiredate            | salary*12*(1+ifnull(commission_pct,0)) |
+-------------+-------------+------------+----------+--------------------+--------+----------+----------------+------------+---------------+---------------------+----------------------------------------+
|         145 | John        | Russell    | JRUSSEL  | 011.44.1344.429268 | SA_MAN | 14000.00 |           0.40 |        100 |            80 | 2002-12-23 00:00:00 |                              235200.00 |
|         146 | Karen       | Partners   | KPARTNER | 011.44.1344.467268 | SA_MAN | 13500.00 |           0.30 |        100 |            80 | 2002-12-23 00:00:00 |                              210600.00 |
|         147 | Alberto     | Errazuriz  | AERRAZUR | 011.44.1344.429278 | SA_MAN | 12000.00 |           0.30 |        100 |            80 | 2002-12-23 00:00:00 |                              187200.00 |
|         168 | Lisa        | Ozer       | LOZER    | 011.44.1343.929268 | SA_REP | 11500.00 |           0.25 |        148 |            80 | 2014-03-05 00:00:00 |                              172500.00 |
|         148 | Gerald      | Cambrault  | GCAMBRAU | 011.44.1344.619268 | SA_MAN | 11000.00 |           0.30 |        100 |            80 | 2002-12-23 00:00:00 |                              171600.00 |
|         174 | Ellen       | Abel       | EABEL    | 011.44.1644.429267 | SA_REP | 11000.00 |           0.30 |        149 |            80 | 2014-03-05 00:00:00 |                              171600.00 |
|         156 | Janette     | K_ing      | JKING    | 011.44.1345.429268 | SA_REP | 10000.00 |           0.35 |        146 |            80 | 2014-03-05 00:00:00 |                              162000.00 |
|         162 | Clara       | Vishney    | CVISHNEY | 011.44.1346.129268 | SA_REP | 10500.00 |           0.25 |        147 |            80 | 2014-03-05 00:00:00 |                              157500.00 |
|         150 | Peter       | Tucker     | PTUCKER  | 011.44.1344.129268 | SA_REP | 10000.00 |           0.30 |        145 |            80 | 2014-03-05 00:00:00 |                              156000.00 |
|         157 | Patrick     | Sully      | PSULLY   | 011.44.1345.929268 | SA_REP |  9500.00 |           0.35 |        146 |            80 | 2014-03-05 00:00:00 |                              153900.00 |
|

按別名排序

對有獎金的員工，按年薪降序

mysql> select *,salary*12*(1+ifnull(commission_pct,0)) nianxin
    -> from employees
    -> order by nianxin desc;    #此處用了重命名
+-------------+-------------+-------------+----------+--------------------+------------+----------+----------------+------------+---------------+---------------------+-----------+
| employee_id | first_name  | last_name   | email    | phone_number       | job_id     | salary   | commission_pct | manager_id | department_id | hiredate            | nianxin   |
+-------------+-------------+-------------+----------+--------------------+------------+----------+----------------+------------+---------------+---------------------+-----------+
|         100 | Steven      | K_ing       | SKING    | 515.123.4567       | AD_PRES    | 24000.00 |           NULL |       NULL |            90 | 1992-04-03 00:00:00 | 288000.00 |
|         145 | John        | Russell     | JRUSSEL  | 011.44.1344.429268 | SA_MAN     | 14000.00 |           0.40 |        100 |            80 | 2002-12-23 00:00:00 | 235200.00 |
|         146 | Karen       | Partners    | KPARTNER | 011.44.1344.467268 | SA_MAN     | 13500.00 |           0.30 |        100

按函式的結果排序

sql中的函式模塊

按姓名的字數長度進行升序

mysql> select last_name
    -> from employees
    -> order by length(last_name);
+-------------+
| last_name   |
+-------------+
| Gee         |
| Seo         |
| Lee         |
| Fox         |
| Fay         |
| Chen        |
| Popp        |
| Khoo        |

按多個欄位排序

查詢員工的姓名、工資、部門編號，先按工資升序，再按部門編號降序

mysql> select last_name,salary,department_id
    -> from employees
    -> order by salary asc,department_id desc;
+-------------+----------+---------------+
| last_name   | salary   | department_id |
+-------------+----------+---------------+
| Olson       |  2100.00 |            50 |
| Markle      |  2200.00 |            50 |
| Philtanker  |  2200.00 |            50 |
| Landry      |  2400.00 |            50 |
| Gee         |  2400.00 |            50 |
| Marlow      |  2500.00 |            50 |
| Patel       |  2500.00 |            50 |
| Vargas      |  2500.00 |            50 |

按列數排序

mysql> select *
    -> from employees
    -> order by 2 desc;
+-------------+-------------+-------------+----------+--------------------+------------+----------+----------------+------------+---------------+---------------------+
| employee_id | first_name  | last_name   | email    | phone_number       | job_id     | salary   | commission_pct | manager_id | department_id | hiredate            |
+-------------+-------------+-------------+----------+--------------------+------------+----------+----------------+------------+---------------+---------------------+
|         180 | Winston     | Taylor      | WTAYLOR  | 650.507.9876       | SH_CLERK   |  3200.00 |           NULL |        120 |            50 | 2014-03-05 00:00:00 |
|         171 | William     | Smith       | WSMITH   | 011.44.1343.629268 | SA_REP     |  7400.00 |           0.15 |        148 |            80 | 2014-03-05 00:00:00 |
|         206 | William     | Gietz       | WGIETZ   | 515.123.8181       | AC_ACCOUNT |  8300.00 |           NULL |        205 |           110 | 2016-03-03 00:00:00 |
|         195 | Vance       | Jones       | VJONES   | 650.501.4876       | SH_CLERK   |  2800.00 |           NULL |        123 |            50 | 2014-03-05 00:00:00 |
|         106 | V

mysql> select *
    -> from employees
    -> order by first_name;
+-------------+-------------+-------------+----------+--------------------+------------+----------+----------------+------------+---------------+---------------------+
| employee_id | first_name  | last_name   | email    | phone_number       | job_id     | salary   | commission_pct | manager_id | department_id | hiredate            |
+-------------+-------------+-------------+----------+--------------------+------------+----------+----------------+------------+---------------+---------------------+
|         121 | Adam        | Fripp       | AFRIPP   | 650.123.2234       | ST_MAN     |  8200.00 |           NULL |        100 |            50 | 2004-02-06 00:00:00 |
|         196 | Alana       | Walsh       | AWALSH   | 650.507.9811       | SH_CLERK   |  3100.00 |           NULL |        124 |            50 | 2014-03-05 00:00:00 |
|         147 | Alberto     | Errazuriz   | AERRAZUR | 011.44.1344.429278 | SA_MAN     | 12000.00 |           0.30 |        100 |            80 | 2002-12-23 00:00:00 |
|         103 | Alexander   | Hunold      | AHUNOLD  | 590.423.4567       | IT_PROG    |  9000.00 |           NULL |        102 |            60 | 1992-04-03 00:00:00 |
|         115 | Alexander   | Khoo        | AKHOO    | 515.127.4562       | PU_CLERK   |  3100.00 |           NULL |        114 |            30 | 2000-09-09 00:00:00 |
|         185 | Alexis      | Bull        | ABULL    | 650.509.2876       | SH_CLERK   |  4100.00 |           NULL |        121 |            50 | 2014-03-05 00:00:00 |
|         158 | Allan       | McEwen      | AMCEWEN  | 011.44.1345.829268 | SA_REP     |  9000.00 |           0.35 |        146 |            80 | 2014-03-05 00:00:00 |
|         175 | Alyssa      | Hutton      | AHUTTON  | 011.44.1644.429266 | SA_REP     |  8800.00 |           0.25 |        149 |            80 | 2014-03-05 00:00:00 |
|         167 | Amit        | Banda       | ABANDA   | 011.44.1346.729268 | SA_REP     |  6200.00 |           0.10 |        147 |            80 | 2014-03-05 00:00:00 |
|

轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/255336.html

標籤：其他

上一篇：Mybatis學習篇（一）

下一篇：小程式資料庫問題

mysql的sqlyog學習筆記（查詢部分）（代碼用命令列顯示 ）

索引

語言

查詢