Insert Records in Table

The Insert data in Table is used to insert records or rows into the table in database.

Insert Records in Table

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.

select * from country;

output is displayed as

Download Source