Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Sql The INSERT INTO Statement

Related Tutorials


 
 

Share on Google+Share on Google+

The INSERT INTO Statement

Advertisement
The INSERT INTO statement is used to insert or add a record of data into the table.

The INSERT INTO Statement

     

The INSERT INTO statement is used to insert or add a record of data into the table.

To insert records into a table, just write the key word INSERT INTO 'table name', and write a list of column names separated by commas, followed by a closing parenthesis then use keyword values, write the list of values enclosed in parenthesis. One more thing we should remember always that strings should be enclosed in single quotes, and numbers should not.

Syntax:

 

 

 

 

INSERT INTO 'table_name'('field_name', 'field_name'. . .)
VALUES ('field_value', 'field_value'. . .);

Insert a New Row

To insert a new row in a database table we have to write the given below code:

INSERT INTO employee 
VALUES ('Amar', 'Designer', 10000, 'amar@roseindia.com');

The output of the above code will be:

employee:

emp_name Position Salary email_id
Amar Designer 10000 amar@roseindia.com

Insert Data in Specified Columns

Let us consider we have a table named employee which have the following records:

emp_name Position Salary email_id
Amar Designer 10000 amar@roseindia.com

Let us consider we want to insert data in field name 'emp_name', 'Position' and in 'email_id' with there specific values then we should use the following SQL statement:

INSERT INTO employee (emp_name, Position, email_id)
VALUES ('Vinod', 'Programmer', 'vinod@roseindia.com');

The output is like:

emp_name Position Salary email_id
Amar Designer 10000 amar@roseindia.com
Vinod Programmer   vinod@roseindia.com
Advertisements

If you enjoyed this post then why not add us on Google+? Add us to your Circles



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: September 15, 2007

Related Tutorials

Discuss: The INSERT INTO Statement   View All Comments

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments:1
dinesh
April 11, 2011
sql

insert into school vaules(&i,'&n',&t,&e,&m,&s,&h); ERROR at line 1: ORA-00928: missing SELECT keyword what is the mistake?
DMCA.com