INSERT

{{#set:Related SQL command=UPDATE |Related SQL command=DELETE |Related SQL command=SELECT }}

INSERT is refers to the SQL command INSERT.

Summary

The INSERT command is used to add or insert data into a table. Syntax may vary between certain types of databases but is generally uniform across multiple vendors.

Syntax

 INSERT INTO <table> [ ( <column> [, <column> [, <column>] [, ... ]]] ) ]
   VALUES ( <value> [, <value> [, <value>, [, ...]]] )

Examples

For example to insert the value "foo" into a column called "bar" into a table with name "baz" do the following:

  INSERT INTO baz ( bar ) VALUES( "foo" )

Note: The foo is encased in double quotes this is required for values other than numeric values.

Using the same example as above but use a numeric value of 400 we will not use the qouting.

  INSERT INTO baz ( bar ) VALUES( 400 )

Excersises

1. Use the sample database and insert and populate it with the data from the [[File::/etc/passwd]].

Additional Information

• Wikipedia on SQL INSERT
• W3Schools on SQL INSERT
• MySQL 5.0 INSERT documentation
• PostgreSQL 9.0 INSERT documentation
• SQLite INSERT documentation