[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  阅读(211)  评论(0)    收藏  举报