Update: Move some data

1. Using Primary Key

   Method: UPDATE <database> FROM <wa>

   Example:

       TABLES SPFLI.

       DATA WA LIKE SPFLI.

       WA-NO=’34051920′.

       WA-COMPANY=’DELTA’.

       UPDATE SPFLI FROM WA.

如 SPFLI 的 Primary Key是 NO, 則會找到 NO=’34051920′
的記錄, 將其 COMPANY欄位異動為 DELTA

2. Using Condition

Method:

        UPDATE  <database>  SET  < f1>=<values>…  WHERE  <condition>

Example:
                 UPDATE  SPFLI  SET  NO=’34051920′
                                        COMPANY = ‘DELTA’
                                  WHERE  TEL=’4526107′.

Related posts