| PostgreSQL 9.6.0 锟街诧拷
| |||
|---|---|---|---|
| 锟斤拷一页 | 锟斤拷一锟斤拷 | 锟斤拷 2. SQL锟斤拷锟斤拷 | 锟斤拷一页 |
锟斤拷锟斤拷锟斤拷锟�UPDATE锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷械锟斤拷小锟斤拷锟斤拷锟斤拷惴拷锟斤拷锟斤拷锟� 11 锟斤拷 28 锟斤拷锟皆猴拷锟斤拷露榷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷龋锟斤拷锟矫达拷锟酵匡拷锟斤拷锟斤拷锟斤拷锟斤拷姆锟绞斤拷锟斤拷锟斤拷锟斤拷荩锟�
UPDATE weather
SET temp_hi = temp_hi - 2, temp_lo = temp_lo - 2
WHERE date > '1994-11-28';
锟斤拷锟斤拷锟斤拷锟捷碉拷锟斤拷状态锟斤拷
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
Hayward | 35 | 52 | | 1994-11-29
(3 rows)