Insert

      Syntax:

INSERT INTO table
(column-1, column-2, ... column-n)
VALUES
(value-1, value-2, ... value-n);

                     If we are inserting datas to entire fields then no need to specify the fieldnames.

       Example:

                 

                INSERT INTO EMPLOYEE_DETAILS  VALUES('Akhilash',22,2500,'Developer');  

   INSERT INTO EMPLOYEE_DETAILS  VALUES('Akhilash',22,250.90,'Developer');
   INSERT INTO EMPLOYEE_DETAILS  VALUES('Akhilash',22,250.90,'Developer');

    OutPut

                         If we want to insert to particular fields then specify that particular fields before 'VALUES' keyword.

    Syntax:        

INSERT INTO suppliers
(supplier_id, supplier_name)
VALUES
(24553, 'IBM');