Syntax:
INSERT INTO
TableName
(Column, Column)
VALUES(NewValue, NewValue);
What does it do?
The INSERT statement adds a new row to a table. Inside the parenthesis after
the TableName you can explicitly state which Columns to add data into, then inside the
parenthesis after the Values, the data for the new row is entered.
Note: if the table has an auto number column, leave that column out of the statement,
an incremented value will automatically be entered for the row.
Syntax - Inserting other table rows:
This method will select all the rows from one table and insert them into another one.
For this version of this method work the destianation table must be an exact duplicate(column names and types).
INSERT INTO
TableName1
SELECT * FROM TableName2;
Syntax - Inserting partial column/row data:
This method will insert paritial column or row data, depending upon the where restriction,
if the where is omitted the whole column data will be inserted
INSERT INTO
TableName1(Column)
SELECT Column FROM TableName2
WHERE TableName2.Column = Value;