Dbms insert into command
Insert into command use for put the record in the specified table.
Syntx:-
First method:-
Insert into"table_name"values(value1,value2);
Second method:-
Insert into"table_name"("column1","column2")values(value1,value2);
Example:-
First method:-
Insert into"student"('1','rahul','mumbai');
Second method:-
Insert into"student"("rollno","name","address")
values('1','rahul','delhi');
Insert into command use for put the record in the specified table.
Syntx:-
First method:-
Insert into"table_name"values(value1,value2);
Second method:-
Insert into"table_name"("column1","column2")values(value1,value2);
Example:-
First method:-
Insert into"student"('1','rahul','mumbai');
Second method:-
Insert into"student"("rollno","name","address")
values('1','rahul','delhi');
Post a Comment
If you have any doubts, Please let me know
Thanks!