id | name | url | alexa | country
----+----------------------+----------------------------------------------------+-------+------------
2 | TaoBao | https://www.taobao.com/ | 13 | CN
1 | Google | https://www.google.com/ | 1 | USA
3 | CaiNiao | http://www.runoob.com/ | 4689 | CN
4 | WeiBo | http://www.weibo.com/ | 20 | CN
5 | FaceBook | http://www.facebook.com/ | 3 | USA
6 | BaiDu | https://www.baidu.com/ | 666 | CN
7 | FaceBook | https://www.facebook.com/ | 755 | USA
| JingDong | https://www.jingdong.com/ | 999 |
(8 rows)
A=> update Websites set id='8',country='CN' where name='JingDong';
UPDATE 1
A=> select * from Websites;
id | name | url | alexa | country
----+----------------------+----------------------------------------------------+-------+------------
2 | TaoBao | https://www.taobao.com/ | 13 | CN
1 | Google | https://www.google.com/ | 1 | USA
3 | CaiNiao | http://www.runoob.com/ | 4689 | CN
4 | WeiBo | http://www.weibo.com/ | 20 | CN
5 | FaceBook | http://www.facebook.com/ | 3 | USA
6 | BaiDu | https://www.baidu.com/ | 666 | CN
7 | FaceBook | https://www.facebook.com/ | 755 | USA
8 | JingDong | https://www.jingdong.com/ | 999 | CN
(8 rows)
Update 警告!
在更新记录时要格外小心!在上面的实例中,如果我们省略了 WHERE 子句,如下所示:
执行以上代码会将 Websites 表中所有数据的 country 改为CN
执行没有 WHERE 子句的 UPDATE 要慎重,再慎重。
A=> update Websites set country='CN';
UPDATE 8
A=> select * from Websites;
id | name | url | alexa | country
----+----------------------+----------------------------------------------------+-------+------------
2 | TaoBao | https://www.taobao.com/ | 13 | CN
1 | Google | https://www.google.com/ | 1 | CN
3 | CaiNiao | http://www.runoob.com/ | 4689 | CN
4 | WeiBo | http://www.weibo.com/ | 20 | CN
5 | FaceBook | http://www.facebook.com/ | 3 | CN
6 | BaiDu | https://www.baidu.com/ | 666 | CN
7 | FaceBook | https://www.facebook.com/ | 755 | CN
8 | JingDong | https://www.jingdong.com/ | 999 | CN
(8 rows)