书签 主页 联系
  • 示例
  • 示例数据库
#1
UPDATE employees SET last_name = 'Lopez' WHERE employee_id = 192;
#2
SELECT employee_id, first_name, last_name FROM employees WHERE employee_id = 192;
#3
SELECT * FROM dependents WHERE employee_id = 192;
#4
UPDATE dependents SET last_name = 'Lopez' WHERE employee_id = 192;
#5
UPDATE dependents SET last_name = ( SELECT last_name FROM employees WHERE employee_id = dependents.employee_id );
表格列表
国家
SELECT * FROM countries;
部门
SELECT * FROM departments;
家属
SELECT * FROM dependents;
员工
SELECT * FROM employees;
职位
SELECT * FROM jobs;
地区
SELECT * FROM locations;
区域
SELECT * FROM regions;
  • SQL 查询
执行
清除 美化 压缩
重新加载
  • 结果