2.9. 役鍴

昄扞臯埇傖䫘 DELETE 变傴傯臘婺役鍴㔗啺螆嘹凹 Hayward 䔇崷愫婉喉懘噘轼闼幽嘹埇傖䫘婋麵䔇变傴檪闼底臯傯臘婺役鍴

DELETE FROM weather WHERE city = 'Hayward';

欔橬匂庯 Hayward 䔇崷愫螄嘘鄘儖赆役鍴㔗

SELECT * FROM weather;

     city      | temp_lo | temp_hi | prcp |    date
---------------+---------+---------+------+------------
 San Francisco |      46 |      50 | 0.25 | 1994-11-27
 San Francisco |      41 |      55 |    0 | 1994-11-29
(2 rows)

嘪䫘婋麵嘵嚟䔇臺埖施婔垔襕償媄

DELETE FROM tablename;

套悩澇橬毺垔溇傽DELETE 儖傯毺垔臘婺役鍴欔橬臯㔗啔認底幋嬉係䂘婉嚔臙挗嘹䇞螴