Thursday, April 14, 2016

Sql Insert

This is SQL tutorial to INSERT data on a table of a database . INSERT INTO is used to add new rows of data in a table .

INSERT INTO Query:

INSERT INTO Tablename (col1, col2,col3)] 
VALUES (value1, value2,value3);
col1, col2,...col3 are the names of the columns in the table, where you insert values.

There is another way to INSERT INTO query use.You not need to specify the columns name .You have to make sure the format of the values is in the same format as the columns in the table.

INSERT INTO Query:

INSERT INTO Tablename
VALUES (value1,value2,value3);

No comments:

Post a Comment