Difference between revisions of "INSERT"
Jump to navigation
Jump to search
| (8 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 |
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> |
|||
INSERT INTO <table> [ ( <column> [, <column> [, <column>] [, ... ]]] ) ] |
INSERT INTO <table> [ ( <column> [, <column> [, <column>] [, ... ]]] ) ] |
||
VALUES ( <value> [, <value> [, <value>, [, ...]]] ) |
VALUES ( <value> [, <value> [, <value>, [, ...]]] ) |
||
</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
- Use the sample database and insert and populate it with the data from the [[File::/etc/passwd]].