Insert :
This command is used to insert new records in
a table.
Syntax - 1:
insert into <table_name>
values
(<value1>,<value2>,….<valuen>);
Ex:
insert into employee_table
values (942,’Sridhar Anumula’,’9393454545’);
Note:
Here values must be specified in table sequence. And text values must be enclosed in single quotes.
Syntax -2 :
insert into
<table_name>(<column_1>, <column_1>,……..<column_n>)
values
(<value_1>,<value_2>,….<value_n>);
Ex:
insert into employee_table(emp_id, emp_name,
emp_phone)
values(943,’Santhoshi
Sridhar’,’9292454545’);
Note:
Here values are inserted into
specified columns respectively.
