The INSERT operator is used to put records into a table


INSERT INTO table-name [(col-name [,col-name]...)] VALUES (constant [,constant]...);

If we are inserting into all fields of a record, we don't have to list the 
individual fields

 example :To  INSERT a new faculty record for Jones, ID #, in CHE as Instructor.

           INSERT
           INTO        faculty
           VALUES  ('987654321', 'jones', 'che', 'instructor');

 This puts the record of Jones into faculty as an instructor for che.