Difference between revisions of "INSERT"

From braindump
Jump to navigation Jump to search
Line 1: Line 1:
[[Category: Module 105.3]]
[[Category: Module 105.3]]
[[Category: SQL]]
[[Category: SQL]]
{{#set:Related SQL commands=UPDATE;DELETE;SELECT}}
{{#set:Related SQL command=UPDATE|Related SQL command=DELETE|Related SQL command=SELECT}}


INSERT is referring to the SQL command '''INSERT'''.
INSERT is referring to the SQL command '''INSERT'''.

Revision as of 01:49, 18 January 2011

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

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>, [, ...]]] )