Insert Records in Table

The Insert data in Table is used to insert records or rows into the
table in database. The Syntax used to insert records into a table is given
below:
insert into Table values('first value',' last value');
The insert into is used to add the records followed by
the name of table. The open parenthesis follow the table name, that include list
of values enclosed inside a parenthesis. The value given into the table will be
positioned at respective rows and match up with column name specified in the
table.
Understand with Example
The Tutorial illustrates an example from Insert data in Table. In this
Tutorial we create a table name 'country'.
The describe country show you the field, data type ,attribute used in
table country.
The insert into syntax is used to add the records into a table
country.
| describe country;
insert into country values('India','Delhi');
|
output is displayed as

The select statement command shows you the list of record
inserted into rows of table country.
output is displayed as

Download Source

|