Difference between revisions of "INSERT"
Jump to navigation
Jump to search
| Line 5: | Line 5: | ||
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. |
||
<pre> |
|||
INSERT INTO <table> [ ( <column> [, <column> [, <column>] [, ... ]]] ) ] |
INSERT INTO <table> [ ( <column> [, <column> [, <column>] [, ... ]]] ) ] |
||
VALUES ( <value> [, <value> [, <value>, [, ...]]] ) |
VALUES ( <value> [, <value> [, <value>, [, ...]]] ) |
||
</pre> |
|||
Revision as of 01:32, 18 January 2011
INSERT is referring to the SQL command INSERT.
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.
INSERT INTO <table> [ ( <column> [, <column> [, <column>] [, ... ]]] ) ] VALUES ( <value> [, <value> [, <value>, [, ...]]] )