YanoRyuichi.com/
Wiki
Blog
GitHub
Sandbox
開始行:
* WHERE内で他のテーブルを参照してDELETE [#f671b557]
** USINGを使って [#p66caca9]
#sh(sql){{
DELETE FROM player p USING team t
WHERE p.team_id = t.team_id AND t.team_name = 'AC Milan'
}}
*** INを使って同じ結果を得るには [#ka80378f]
#sh(sql){{
DELETE FROM player WHERE team_id IN ( SELECT team_id FRO...
}}
終了行:
* WHERE内で他のテーブルを参照してDELETE [#f671b557]
** USINGを使って [#p66caca9]
#sh(sql){{
DELETE FROM player p USING team t
WHERE p.team_id = t.team_id AND t.team_name = 'AC Milan'
}}
*** INを使って同じ結果を得るには [#ka80378f]
#sh(sql){{
DELETE FROM player WHERE team_id IN ( SELECT team_id FRO...
}}
ページ名:
