insert用法小结：

1,insert into db_table values wa.

2,insert db_table from table itab.

 

1,The new row is inserted in the database table if this does not already contain a row with the same primary key or the same unique secondary index. If it does, the row is not inserted and sy-subrc is set to 4.

 

2,

If a row with the same primary key or a same unique secondary index already exists in the database table for one or more of the rows to be inserted, these rows cannot be inserted. In this situation, there are three possibilities:

a,use   ACCEPTING DUPLICATE KEYS

b,Handling an exception ,CX_SY_OPEN_SQL_DB

c,Runtime error

 

关于数据的操作，要小心。。。。。。