ブックマーク ホーム 連絡先
  • 例
  • サンプルデータベース
#1
DELETE FROM dependents WHERE dependent_id = 16;
#2
SELECT count(*) FROM dependents WHERE dependent_id = 16;
#3
DELETE FROM dependents WHERE employee_id IN (100 , 101, 102);
#4
DELETE FROM employees WHERE employee_id = 192; DELETE FROM dependents WHERE employee_id = 192;
#5
DELETE FROM employees WHERE employee_id = 192;
テーブル一覧
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 クエリ
実行
クリア キレイにする 最小化する
リロード
  • 結果