ブックマーク ホーム お問い合わせ
  • 例
  • サンプルデータベース
#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クエリ
実行
クリア 美化 圧縮
リロード
  • 結果