PostgreSQL 9.6.0 锟街诧拷
锟斤拷一页锟斤拷一锟斤拷锟斤拷 2. SQL锟斤拷锟斤拷锟斤拷一页

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锟斤拷锟斤拷指锟斤拷锟斤拷锟斤拷删锟斤拷锟斤拷锟斤拷锟叫ｏ拷锟斤拷锟斤拷锟斤拷铡锟斤拷锟斤拷锟叫┲跋低筹拷锟斤拷锟斤拷锟斤拷锟斤拷锟饺凤拷希锟�

锟斤拷一页锟斤拷始页锟斤拷一页
锟斤拷锟斤拷锟斤拷一锟斤拷锟竭硷拷锟斤拷锟斤拷