INSERT INTO ... SELECT
when doing INSERT INTO ... SELECT ... to load data from a table from another one. Does the INSERT start before the end of the SELECT?
example: INSERT INTO films SELECT * FROM tmp_films WHERE date_prod < '2004-05-07';
Solution 1:
First, the data is collected from the SELECT query. Afterwards, this data is given to the INSERT statement.
Also check out the docs here: SQL-INSERT