书签 主页 联系我们
  • 示例
  • 示例数据库
#1
INSERT INTO dependents ( first_name, last_name, relationship, employee_id ) VALUES ( 'Dustin', 'Johnson', 'Child', 178 );
#2
SELECT * FROM dependents WHERE employee_id = 178;
#3
INSERT INTO dependents ( first_name, last_name, relationship, employee_id ) VALUES ( 'Cameron', 'Bell', 'Child', 192 ), ( 'Michelle', 'Bell', 'Child', 192 );
#4
SELECT * FROM dependents WHERE employee_id = 192;
#5
INSERT INTO dependents_archive SELECT * FROM dependents;
#6
SELECT * FROM dependents_archive;
表格列表
countries
SELECT * FROM countries;
departments
SELECT * FROM departments;
dependents
SELECT * FROM dependents;
employees
SELECT * FROM employees;
jobs
SELECT * FROM jobs;
locations
SELECT * FROM locations;
regions
SELECT * FROM regions;
  • SQL 查询
执行
清除 美化 缩小
重新加载
  • 结果