[Postgres] Update and Delete records in Postgres

Delete example:

DELETE FROM movies
WHERE count_stars > 70;

 

Update example:

UPDATE movies
SET count_stars=3
WHERE count_stars=2;

 

posted @ 2017-03-09 01:45  Zhentiw  阅读(200)  评论(0编辑  收藏  举报