1. Home
  2. Computing & Technology
  3. Databases

Inserting Data with the SQL INSERT Command

By Mike Chapple, About.com

The INSERT command in SQL is used to add records to an existing table. Imagine that our HR department needs to add a new employee to their database. They could use a command similar to the one shown below:
INSERT INTO personal_info
values('bart','simpson',12345,$45000)
Note that there are four values specified for the record. These correspond to the table attributes in the order they were defined: first_name, last_name, employee_id, and salary.

Learning More

If you would like to learn more about the Structured Query Language, read Introduction to SQL or sign up for our free Learning SQL e-mail course.
Explore Databases
About.com Special Features

Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >

Easy ways to connect two computers for networking purposes. More >

  1. Home
  2. Computing & Technology
  3. Databases
  4. Learning SQL
  5. Inserting Data with the SQL INSERT Command>

©2009 About.com, a part of The New York Times Company.

All rights reserved.