SQL
INSERT INTO Statement

INSERT INTO statement is used to insert the records in table. We can insert records in table in two ways, the most commonly used way for insert is to specify both the column names and values.

All Columns

In this method there is no need to specify the column names in SQL query, however make sure the order of the values and columns.

Syntax
                    

  INSERT INTO table_name
  VALUES (value1, value2, value3, ...);

 

Example
                    

  INSERT INTO Customers
  VALUES ('john', 'Michel john ', 'St 55', 'louse angelus', '4900', 'USA');

Selective Columns

Syntax
                    

  INSERT INTO table_name (column1, column2, column3, ...)
  VALUES (value1, value2, value3, ...); 

 

Example
                    

    INSERT INTO Customers (CustomerName, ContactName, Address, City, PostalCode, Country)
    VALUES ('john', 'Michel john ', 'St 55', 'louse angelus', '4900', 'USA');