Difference between revisions of "INSERT"

From braindump
Jump to navigation Jump to search
 
(7 intermediate revisions by the same user not shown)
Line 1: Line 1:
[[Category: Module 105.3]]
[[Category: Module 105.3]]
[[Category: SQL]]
[[Category: SQL]]
{{#set:Related SQL command=UPDATE
|Related SQL command=DELETE
|Related SQL command=SELECT
}}


INSERT is referring to the SQL command '''INSERT'''.
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.
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 ==
<pre>
<pre>
INSERT INTO <table> [ ( <column> [, <column> [, <column>] [, ... ]]] ) ]
INSERT INTO <table> [ ( <column> [, <column> [, <column>] [, ... ]]] ) ]
VALUES ( <value> [, <value> [, <value>, [, ...]]] )
VALUES ( <value> [, <value> [, <value>, [, ...]]] )
</pre>
</pre>

== Examples ==
For example to insert the value "foo" into a column called "bar" into a table with name "baz" do the following:
<pre>
INSERT INTO baz ( bar ) VALUES( "foo" )
</pre>
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.
<pre>
INSERT INTO baz ( bar ) VALUES( 400 )
</pre>

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

== Additional Information ==
* [http://en.wikipedia.org/wiki/Insert_%28SQL%29 Wikipedia on SQL INSERT]
* [http://www.w3schools.com/SQL/sql_insert.asp W3Schools on SQL INSERT]
* [http://dev.mysql.com/doc/refman/5.0/en/insert.html MySQL 5.0 INSERT documentation]
* [http://www.postgresql.org/docs/9.0/static/sql-insert.html PostgreSQL 9.0 INSERT documentation]
* [http://www.sqlite.org/lang_insert.html SQLite INSERT documentation]

Latest revision as of 02:49, 19 January 2011

{{#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