查询表中的字段
-
SELECT last_name FROM employees
-
查询表中的多个字段
SELECT last_name,salary,email FROM employees
-
`employee_id`,
`first_name`,
`last_name`,
`phone_number`,
`last_name`,
`job_id`,
`phone_number`,
`job_id`,
`salary`,
`commission_pct`,
`manager_id`,
`department_id`,
`hiredate`
FROM
employees ;
**方式二:字段的顺序和,原始表一样。**
SELECT * FROM employees;