mysql基础

#查看数据库有哪些表
SHOW TABLES;
#查看表的所有列
SELECT * FROM employees;
#查看表的指定列
SELECT first_name FROM employees;
#查看表的多列
SELECT first_name,last_name FROM employees;
#表的别名
SELECT first_name zhang ,last_name zhang1
FROM employees;
#显示表的结构
DESCRIBE employees;
DESC jobs;
#显示有哪些数据库
SHOW DATABASES;
#5.显示出表employees中的全部job_id（不能重复）
SELECT DISTINCT job_id FROM employees;
SELECT * FROM jobs;
#显示表中薪水大学17000的信息
SELECT * FROM employees WHERE salary>17000;
##6.显示出表employees的全部列，各个列之间用逗号连接，列头显示成OUT_PUT
SELECT employee_id “员工的id”,last_name “员工的性”,first_name “员工的名字” FROM employees;

##过滤和排序
#1查询工资大于12000的员工姓名和工资
SELECT salary ,last_name
FROM employees
WHERE salary >12000;