Chapter 5, Problem 1RQ

Which command should you use to copy data from one table and have it added to an existing table?

Explanation of Solution

“INSERT INTO” command:

• This command is used to insert the values in a table.
• The INSERT command in SQL is employed to add records to an existing table.
• INSERT will increase the number of rows in a table.

Syntax for “INSERT INTO” command:

INSERT INTO table_name VALUES (valuel, value2,...);

Example:

  INSERT INTO employee VALUES (101, ‘Smith',10);