                     ----------  Update  ----------

   ơ֥Υ쥳ɤ򹹿ˤϡ˼÷ޥɤ顢ڥ졼
 󥰥ƥΥե뤫顢°ͤϤ¥÷󥿡ե顢
 줾줬ѤǤޤ

1) ÷ޥɤˤꡢ쥳ɤ򹹿ˤϼΤɤ줫Ѥޤ

 ιʸ

a)   update TABLE set ATTR_NAME |= | |EXPR|
                                |to| |null|

         {, ATTR_NAME |= | |EXPR|} [WHERE_CLAUSE];
                      |to| |null|

b)   update TABLE  | set to |EXPR| {, |EXPR|}   | [WHERE_CLAUSE];
                   |        |null|    |null|    |
                   |                            |
                   | values |EXPR| {, |EXPR|}   |
                   |        |null|    |null|    |
                   |                            |
                   | values (|EXPR| {, |EXPR|}) |
                   |         |null|    |null|   |

c)   update TABLE |(*)                      | | set to |EXPR| {, |EXPR| }   |
                  |(ATTR_NAME {, ATTR_NAME})| |        |null|    |null|     |
                                              |                             |
                                              | |EXPR| {, |EXPR| } [end]    |
                                              | |null|    |null|            |
                                              |                             |
                                              | values |EXPR| {, |EXPR| }   |
                                              |        |null|    |null|     |
                                              |                             |
                                              | values (|EXPR| {, |EXPR|})  |
                                              |         |null|    |null|    |

        [WHERE_CLAUSE];

d)   update TABLE set |*                      | | |EXPR| {, |EXPR| } [end]   |
                      |ATTR_NAME {, ATTR_NAME}| | |null|    |null|           |
                                                |                            |
                                                | values |EXPR| {, |EXPR| }  |
                                                |        |null|    |null|    |
                                                |                            |
                                                | values (|EXPR| {, |EXPR|}) |
                                                |         |null|    |null|   |

        [WHERE_CLAUSE];

   ͤ򥳥ޥ˻ꤹ뤳ȤˤꡢWHERE 쥳ɤޤ
 줾ͤϻꤵ줿°졢ꤵʤ°Ϲޤ

   ˾ɬפʾϡʲ˼ޥɤϤƤ

                help expr;
                help where_clause;


2) ڥ졼ƥ󥰥ƥΥե뤫쥳ɤ򹹿ˤϼͤˤޤ  
 ιʸ

     update TABLE [ | (*)               | ] from FILE [WHERE_CLAUSE];
                    | (ATTR {, ATTR})   |
                    | set *             |
                    | set ATTR {, ATTR} |

   WHERE ʣΥ쥳ɤͤե FILE ˻ꤷޤ

   FILE °ͤ CTRL-Vʾά͡ˤǶڤäưԤ˰쥳ɤȤ뤫뤤
 Ԥ˰°ͤȤʤФʤޤATTR ꤵƤϡFILE 
 Ʊ֤Ȥʤޤ

3) ÷󥿥եѤƥ쥳ɤ򹹿ˤϼΤ褦ˤޤ

 ιʸ

a)   update TABLE [WHERE_CLAUSE];

b)   update TABLE |(*)            | [WHERE_CLAUSE];
                  |(ITEM {, ITEM})|

c)   update TABLE |set ||*            | {[:] |set ||*            |}
                  |show||ITEM {, ITEM}|      |show||ITEM {, ITEM}|
     [WHERE_CLAUSE];

ITEM : ATTR [print HEADER]

   ñ "update TABLE" ȤȡTABLEƤ°ˤĤơʾά͡ˤν֤ǹ
 ¥ޤޤ°ΥꥹȤꤹȤν֤ͤι¥ޤ
   ˡ"*" ȤȤΥơ֥Ƥ°ˤĤƹ¥ޤ

    "set" ͤιǤ "show" ñ°̾ȡФͤɽ
 Ȥʤޤ

   WHERE ꤷϡ쥳ɤ¥ޤ

   ÷󥿡եΥޥɤˤĤƤ˾ɬפʾϡʲΥ
 ɤϤƤ

                help ia_update;
