MySQL8 过滤数据 where

过滤数据：WHERE

SELECT * FROM employees

WHERE department_id = 90;

mysql> SELECT * FROM employees
    ->     WHERE department_id = 90;
+-------------+------------+-----------+----------+--------------+------------+---------+----------+----------------+------------+---------------+
| employee_id | first_name | last_name | email    | phone_number | hire_date  | job_id  | salary   | commission_pct | manager_id | department_id |
+-------------+------------+-----------+----------+--------------+------------+---------+----------+----------------+------------+---------------+
|         100 | Steven     | King      | SKING    | 515.123.4567 | 1987-06-17 | AD_PRES | 24000.00 |           NULL |       NULL |            90 |
|         101 | Neena      | Kochhar   | NKOCHHAR | 515.123.4568 | 1989-09-21 | AD_VP   | 17000.00 |           NULL |        100 |            90 |
|         102 | Lex        | De Haan   | LDEHAAN  | 515.123.4569 | 1993-01-13 | AD_VP   | 17000.00 |           NULL |        100 |            90 |
+-------------+------------+-----------+----------+--------------+------------+---------+----------+----------------+------------+---------------+
3 rows in set (0.00 sec)

生活的强者，不是指能搞定一切困难，也不是指没有恐惧，而是就算心里藏着无尽的疲惫和委屈，还是会认真地做好手头上的事情；就算自己被生活锤得心灰意冷，还是会尽心尽力地负起责任；就算发现现实与理想的差距有十万里，虽然鞭长莫及，却依然马不停蹄。

MySQL8 过滤数据 where

评论

相关文章