‹ BACK

INSERT Query

INSERT Query

Populate one table using another table: You can populate data into a table through select statement over another table provided another table has a set of fields, which are required to populate first table. Here is the syntax:
INSERT INTO first_table_name [(column1, column2, ... columnN)] 
   SELECT column1, column2, ...columnN 
   FROM second_table_name
   [WHERE condition];

Read more.
SELECT-clause INSERT-statement

To check your knowledge the following tests are recommended:
Check your sql sql skills.