查询表中的单个字段
SELECT
last_name
FROM
employees ;
查询表中的多个字段
SELECT
last_name,
salary,
email
FROM
employees ;
查询表中的所有字段
方式一:
SELECT
`employee_id`,
`first_name`,
`phone_number`,
`commission_pct`,
`manager_id`,
`department_id`,
`hiredate`
FROM
employees ;
Copy to clipboardErrorCopied
方式二:
SELECT * FROM employees;