SQL INSERT INTO Command

The INSERT INTO comman is used to insert new records in a table.

SQL INSERT INTO Syntax:

INSERT INTO table_name (column_1_name,column_2_name_,column_3_name,...)
VALUES (value_1,value_2,value_3,...)

OR

  INSERT INTO table_name
  VALUES (value_1,value_2,value_3,...)

As you see, we have like this "Candidate" table.

Example:

  INSERT INTO CANDIDATE
 (
   CandidateNumber,
   FirstName,
   LastName,
   PostCode,
   Address,
   Phone
)
VALUES
 (
   '1269910',
   'Harsh',
   'sojitra',
   '365641',
   'Norway',
   '4512981234'
)

Output: