Difference between revisions of "INSERT"
		
		
		
		
		
		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  | {{#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>, [, ...]]] )