mysql练习基础一

澜然

已于 2022-04-18 15:18:05 修改

阅读量647

点赞数 1

分类专栏： MySQL 文章标签： sql

于 2022-04-18 14:45:05 首次发布

本文链接：https://blog.csdn.net/weixin_48378125/article/details/124249245

版权

15 篇文章 0 订阅

订阅专栏

SELECT * FROM employees;

SELECT DISTINCT job_id  FROM employees

SELECT CONCAT(employee_id,',',first_name,',',last_name,',',email) OUT_PUT FROM employees;

SELECT * FROM employees WHERE department_id in (20,50);

SELECT * FROM employees WHERE department_id in (20,50);

SELECT last_name,department_id FROM employees WHERE manager_id is null;

SELECT last_name,department_id FROM employees WHERE manager_id <=>null;

SELECT last_name,salary,commission_pct FROM employees WHERE commission_pct is NOT null;

SELECT last_name FROM employees WHERE last_name like '__a%';

SELECT last_name FROM employees WHERE last_name like '%a%' and last_name like '%e%';

SELECT * FROM employees WHERE first_name LIKE '%e';

SELECT last_name ,job_id,department_id FROM employees WHERE department_id BETWEEN 80 and 100;

SELECT	last_name,job_id,manager_id FROM employees WHERE manager_id in (100,101,110);

不一样
SELECT * FROM employees 
SELECT * FROM employees WHERE commission_pct LIKE '%%' and  last_name like  '%%'  会排除掉null值

desc departments;

关注