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:

Insert Data in Specified Columns

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

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:

Related Tags for The INSERT INTO Statement:
c,  com,  list,  table,  insert,  sed,  word,  column,  key,  value,  name,  int,  write,  tab,  parent,  close,  record,  keyword,  records,  values,  to,  names,  e,  it,  comma,  li,  use,  in,  thesis,  as,  closing,  m,  nt,  par,  separate,  os,  osi,  closed,  osi,  os,  j,  cl,  es,  me,  into,  rate,  umn,  s,  col,  at,  k,  is,  ll,  parenthesis,  follow,  and,  ar,  clos,  rds,  rt,  va,  s,  s,  ri,  rd,  ren,  th,  st,  ab,  abl,  alu,  esi,  esi,  lum,  nd,  om,  ol,  o

More Tutorials from this section

• SQL Example, Codes and Tutorials
• Aggregate Functions
• Backup File With Separator
• Backup Into txt File
• Backup selected records into txt file
• Call Procedure
• Close Cursors in SQL
• Create After Insert Trigger in SQL
• Create Before Insert Trigger in SQL
• Create Before Update Trigger in SQL
• Create Delete Trigger in SQL
• Create a Simple Procedure
• Create After Update Trigger in SQL
• Create a database
• Creating Cursors in SQL
• The Normal Forms
• Database Normalization
• Second Normal Form (2NF)
• Third Normal Form (1NF)
• Data Normalization

Ask Questions?    Discuss: The INSERT INTO Statement   View All Comments

Post your Comment

Your Name (*) :

Your Email :
Subject (*):
Your Comment (*):