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');