SQL – INSERT
SQL – INSERT Statement :
SQL INSERT INTO Statemet is used to insert new row(ie. record) in table.
SQL INSERT INTO Syntax :
Note : The Above Sytax inserts rows in all columns of the table .
If You want to insert values in seleted columns the following syntax is used :
EXAMPLE 1 (Insert in all column) :
1 New row will be inserted.
Now the table has its first record after the selection it will show :
EXAMPLE 2 (Insert in few columns only) :
Note : We need to specify the column name in which we want to insert values Like If want to insert values in ID, Name and Email Columns only. .
Now the table will look like :