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.
Войдите чтобы поставить Нравится
Войдите чтобы прокомментировать