DB Manipulation

1. delete, insert, modify
   these operations which may alter the contents of a table have to be done before any change to the table happens.
2. 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)