Open SQL SELECT SELECT INTO SELECT field 1

Open SQL

数据库表选取 • SELECT – SELECT … INTO … 覆盖数据 • 数据库表循环语句 SELECT field 1 field 2 field 3 FROM database table INTO [CORRESPONDING FIELDS OF] wa. APPEND wa TO itab. ENDSELECT. • 选取多条数据 SELECT field 1 field 2 field 3 FROM database table INTO [CORRESPONDING FIELDS OF] TABLE itab. • 选取单条 SELECT SINGLE field 1 field 2 field 3 FROM database table INTO [CORRESPONDING FIELDS OF] wa. – SELECT … APPENDING … 追加数据 • 语法规则类似，不会覆盖内表中的数据，而是在原本的内表中追加数据

数据库表删除 • DELETE – 删除主键相同的数据，如果数据库表中不存在，删除失败 DELETE db FROM TABLE itab. DELETE db FROM wa. DELETE FROM db WHERE field = val.