SQL INSERT Statement Column names and values

SQL INSERT statement is used to insert a new row in a table with respective Database.

There is two Method using INSERT INTO statement for inserting rows:

• Only Values
• Column names and values both

Only Values: Syntax

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

table_name: name of the table.
value1, value2,.. : value of first column, second column,third column...

Column names and values both: Syntax

INSERT INTO table_name (column1, column2, column3,..) VALUES ( value1, value2, value3,..);
table_name: name of the table.
column1: name of first column, second column ...
value1, value2, value3 : value of first column, second column, third column... for the new records

SQL INSERT Statement

Student Table

Add a new record in Student Table

INSERT INTO Student (FirstName, LastName, City, Country, Phone)
VALUES ('Shaym', 'Shukla', 'London', 'USA', 6578964534)

Resource
SQL