Difference between revisions of "INSERT"

From braindump
Jump to navigation Jump to search
(Created page with "Category: Module 105.3 Category: SQL INSERT is referring to the SQL command.")
 
Line 2: Line 2:
[[Category: SQL]]
[[Category: SQL]]


INSERT is referring to the SQL command.
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>, [, ...]]] )

Revision as of 01:31, 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

[ ( <column> [, <column> [, <column>] [, ... ]]] ) ] VALUES ( <value> [, <value> [, <value>, [, ...]]] )