数据库操作

：查询 *&---------------------------------------------------------------------* *& Report ZHANSEN27 *&---------------------------------------------------------------------* *& *&---------------------------------------------------------------------* REPORT ZHANSEN27. DATA country TYPE string. "查询一个字段 SELECT CARRID INTO country FROM SPFLI. ENDSELECT. write: / country. data: wa_carrid type spfli-carrid, wa_connid type spfli-connid. select single carrid connid from spfli "查询指定的多个字段。 into (wa_carrid,wa_connid) where cityfrom = ‘singapore‘. write: / wa_carrid. write: / wa_connid. data wa_spfli type spfli. select * from spfli into wa_spfli where cityfrom = ‘SINGAPORE‘. "select the whole table and looply print. write: / wa_spfli-carrid. endselect.

 result:

2: insert

 

数据库操作

标签：mamicode   insert   int   col   png   result   amp   city   数据