mysql基础语法第二天

#数据库查询
SELECT * FROM employees
#查询员工的id
SELECT employee_id FROM employees
#查询员工的first_name
SELECT first_name FROM employees;
#查询员工的id和first_name
SELECT first_name ,last_name
SELECT employee_id ,first_name, last_name ,salary*12 “公司员工的年薪” FROM employees;
FROM employees;
#查询员工的全部信息
SELECT * FROM jobs;
SELECT * FROM locations;
#查询多条信息
SELECT last_name , job_id , salary AS sal
FROM employees;
#判断语句是否可以成功执行(不可以成功执行)只可以查询表
SELECT * FROM employees;
#修改下列语句
SELECT employee_id , last_name,salary * 12 ‘ANNUAL SALARY’
FROM employees;
SELECT * FROM employees;
#显示表的结构(显示employees中标的结构组成和数据结构)(可以用关键只desc关键词来代替describe)
DESCRIBE employees;