| PostgreSQL 7.4.6 ʸ½ñ | ||||
|---|---|---|---|---|
| Á°¤Î¥Ú¡¼¥¸ | ´¬Ìᤷ | ÁáÁ÷¤ê | ¼¡¤Î¥Ú¡¼¥¸ | |
UPDATE [ ONLY ] table SET column = { expression | DEFAULT } [, ...]
[ FROM fromlist ]
[ WHERE condition ]UPDATE ¤Ï¡¢¾ò·ï¤òËþ¤¿¤¹Á´¤Æ¤Î¹Ô¤Î»ØÄꤵ¤ì¤¿Îó¤ÎÃͤòÊѹ¹¤·¤Þ¤¹¡£ Êѹ¹¤µ¤ì¤ë¤Ù¤Îó¤Î¤ß¤¬Ê¸Æâ¤Îcolumns¥Ñ¥é¥á¡¼¥¿¤Ë¤¢¤ëɬÍפ¬¤¢¤ê¤Þ¤¹¡£ SET ¤Ë¤ÆÌÀ¼¨Åª¤ËÀßÄꤵ¤ì¤Ê¤«¤Ã¤¿Îó¤ÎÃͤÏÊѹ¹¤µ¤ì¤Þ¤»¤ó¡£
¥Ç¥Õ¥©¥ë¥È¤Ç¡¢UPDATE¤Ï»ØÄꤵ¤ì¤¿¥Æ¡¼¥Ö¥ë¤È¤½¤Î¥µ¥Ö¥Æ¡¼¥Ö¥ë¤Î¥¿¥×¥ë¤ò¹¹¿·¤·¤Þ¤¹¡£ »ØÄꤵ¤ì¤¿¥Æ¡¼¥Ö¥ë¤Î¤ß¤ò¹¹¿·¤·¤¿¤¤¾ì¹ç¤Ï ONLY ¶ç¤ò»ÈÍѤ·¤Æ²¼¤µ¤¤¡£
¥Æ¡¼¥Ö¥ë¤òÊѹ¹¤¹¤ë¤¿¤á¤Ë¤ÏUPDATE¸¢¸Â¤¬É¬ÍפǤ¹¡£ ¤¢¤ï¤»¤Æ¡¢ expression¤äcondition¤ÇÆɤ߹þ¤Þ¤ì¤ë¥Æ¡¼¥Ö¥ë¤Ø¤Î SELECT ¸¢¸Â¤âɬÍפˤʤê¤Þ¤¹¡£
¹¹¿·ÂоݤΥơ¼¥Ö¥ë¤Î̾Á°¤Ç¤¹ (¥¹¥¡¼¥Þ½¤¾þ̾¤Ç¤â²Ä)¡£
tableÆâ¤ÎÎó̾¤Ç¤¹¡£
Îó¤ËÂåÆþ¤¹¤ë¼°¤Ç¤¹¡£ ¥Æ¡¼¥Ö¥ëÆâ¤ÎÂоÝÎó¤ä¤½¤Î¾¤ÎÎó¤Î¸Å¤¤Ãͤò¼°¤Ë»ÈÍѤ¹¤ë¤³¤È¤¬¤Ç¤¤Þ¤¹¡£
Îó¤Ë¤½¤Î¥Ç¥Õ¥©¥ë¥ÈÃͤòÀßÄꤷ¤Þ¤¹¡£ (ÆÃÄê¤Î¥Ç¥Õ¥©¥ë¥È¼°¤¬Îó¤Ë³ä¤êÅö¤Æ¤é¤ì¤Æ¤¤¤Ê¤¤¾ì¹ç¤ÏNULL¤Ë¤Ê¤ê¤Þ¤¹¡£)
WHERE ¾ò·ï¤ä¹¹¿·ÍѤμ°¤Ë¾¤Î¥Æ¡¼¥Ö¥ë¾å¤ÎÎó¤ò»ØÄê¤Ç¤¤ë¤è¤¦¤Ë¤¹¤ë¡¢¥Æ¡¼¥Ö¥ë¼°¤Î½¸¹ç¤Ç¤¹¡£
boolean·¿¤ÎÃͤòÊÖ¤¹¼°¤Ç¤¹¡£ ¤³¤Î¼°¤¬true¤òÊÖ¤¹¹Ô¤Î¤ß¤¬¹¹¿·¤µ¤ì¤Þ¤¹¡£
Àµ¾ï¤Ë½èÍý¤¬½ª¤ë¤È¡¢UPDATE¥³¥Þ¥ó¥É¤Ï°Ê²¼¤Î·Á¼°¤Î¥³¥Þ¥ó¥É¥¿¥°¤òÊÖ¤·¤Þ¤¹¡£
UPDATE count
count ¤Ï¹¹¿·¤µ¤ì¤¿¹Ô¿ô¤ò°ÕÌ£¤·¤Þ¤¹¡£ count¤¬0¤Î¾ì¹ç¤Ïcondition¤Ë°ìÃפ¹¤ë¹Ô¤¬¤Ê¤«¤Ã¤¿¤³¤È¤ò°ÕÌ£¤·¤Þ¤¹¡£ (¤³¤ì¤Ï¥¨¥é¡¼¤È¤Ï¤ß¤Ê¤µ¤ì¤Þ¤»¤ó¡£)
films¥Æ¡¼¥Ö¥ë¤Îkind Îó¤Ë¤¢¤ë Drama ¤È¤¤¤¦Ã±¸ì¤ò Dramatic ¤ËÊѹ¹¤·¤Þ¤¹¡£
UPDATE films SET kind = 'Dramatic' WHERE kind = 'Drama';
weather¥Æ¡¼¥Ö¥ë¤Î¤¢¤ë¹Ô¤ËÂФ·¡¢µ¤²¹¹àÌܤòÄ´À°¤·¡¢¹ß¿åÎ̤ò¥Ç¥Õ¥©¥ë¥ÈÃͤËÌᤷ¤Þ¤¹¡£
UPDATE weather SET temp_lo = temp_lo+1, temp_hi = temp_lo+15, prcp = DEFAULT WHERE city = 'San Francisco' AND date = '2003-07-03';
| Á°¤Î¥Ú¡¼¥¸ | ¥Û¡¼¥à | ¼¡¤Î¥Ú¡¼¥¸ |
| UNLISTEN | ¾å¤ËÌá¤ë | VACUUM |