INSERT
{{#set:Related SQL command=UPDATE |Related SQL command=DELETE |Related SQL command=SELECT }}
INSERT is refers to the SQL command INSERT.
Summary
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.
Syntax
INSERT INTO <table> [ ( <column> [, <column> [, <column>] [, ... ]]] ) ] VALUES ( <value> [, <value> [, <value>, [, ...]]] )
Examples
For example to insert the value "foo" into a column called "bar" into a table with name "baz" do the following:
INSERT INTO baz ( bar ) VALUES( "foo" )
Note: The foo is encased in double quotes this is required for values other than numeric values.
Using the same example as above but use a numeric value of 400 we will not use the qouting.
INSERT INTO baz ( bar ) VALUES( 400 )
Excersises
- Use the sample database and insert and populate it with the data from the [[File::/etc/passwd]].