Difference between revisions of "Insert Queries"

From TRCCompSci - AQA Computer Science
Jump to: navigation, search
(Created page with "INSERT adds rows to an existing table, there can be different syntax depending on specific version of SQL etc ==Best Method== <SyntaxHighlight lang=sql> INSERT INTO table ...")
(No difference)

Revision as of 14:23, 17 December 2016

INSERT adds rows to an existing table, there can be different syntax depending on specific version of SQL etc

Best Method

 INSERT INTO table
 (field1, field2, field3)
 VALUES
 (value1, value2, value3);

Alternative Method

 INSERT INTO table
 VALUES
 (value1, value2, value3);