insert query in sql | Sharp Tutorial

SQL Insert Query

insert query is used to insert the records into the given table

Syntax: insert into <table-name> values(value1,value2,…….);

   insert into login values('user' , '1234', 'normal-user','offline');

If we have to insert some field values in a table.then Syntax: insert into <table-name> (column1,column2,….) values(value1,value2,…….);

   insert into login (userid,password) values ('admin' , '007');

in the above query only values is inserted as per given , the third field value is the default value.