DELETE 구문을 사용하면 테이블 내에 불필요한 데이터를 삭제할 수 있다.
DELETE
FROM table _spec [ correlation ]
[ WHEREsearch_condition ] [ ; ]
correlation :
[ AS ] identifier [ {, identifier }_ ]
table_spec :
single_table_spec
( single_table_spec [ {, single_table_spec }_ ] )
single_table_spec :
[ ONLY ] table_name
ALL table_name [ EXCEPTtable_spec ]
DELETE FROM stadium;
DELETE FROM olympic WHERE host_year = 1980;