Home Sql Sqlbeginner Insert Records in Table
Questions:Ask|Latest


 
 

Share on Google+Share on Google+

Insert Records in Table

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

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

Advertisements

Liked it!  Share this Tutorial


Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Posted on: December 12, 2008

Ask Questions?    Discuss: Insert Records in Table   View All Comments

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments
DMCA.com