runoobdb# select * from COMPANY;
id | name | age | address | salary
----+-------+-----+-----------+--------1|Paul|32|California|200002|Allen|25|Texas|150003|Teddy|23|Norway|200004|Mark|25|Rich-Mond|650005|David|27|Texas|850006|Kim|22|South-Hall|450007|James|24|Houston|10000(7 rows)
以下 SQL 语句将删除 ID 为 2 的数据:
runoobdb=# DELETE FROM COMPANY WHERE ID =2;
得到结果如下:
id | name | age | address | salary
----+-------+-----+-------------+--------1|Paul|32|California|200003|Teddy|23|Norway|200004|Mark|25|Rich-Mond|650005|David|27|Texas|850006|Kim|22|South-Hall|450007|James|24|Houston|10000(6 rows)