- delete, insert, modify
these operations which may alter the contents of a table have to be done before any change to the table happens. - insert
- insert into table values(column_v1, column_v2, column_v3, … , column_vn)
the values to be inserted are in the order in which the corresponding attributes are listed in the relation schema - insert into table (column_n1,column_n2, column_n3, … , column_nn) values(column_v1, columnv2,column_v3, … , column_vn)
- insert into table (select clause)
- insert into table values(column_v1, column_v2, column_v3, … , column_vn)
DB Manipulation
最新推荐文章于 2021-02-18 12:13:34 发布