insert into from select

public

andrei.k Sep 28, 2023 Never 28

SQL paste1.sql 5 lines (3 loc) | 302 Bytes

Raw

1 INSERT INTO table1 ( column1 ) SELECT col1 FROM table2
2  
3 -- EXAMPLE
4  
5 insert into impressions_summary (day, package_name, platform, idfa, idfv, user_id, all_revenue) select day, package_name, platform, idfa, idfv, user_id, all_revenue from impressions where day >= '2023-01-01' and day < yesterday();

1	INSERT INTO table1 ( column1 ) SELECT col1 FROM table2
2
3	-- EXAMPLE
4
5	insert into impressions_summary (day, package_name, platform, idfa, idfv, user_id, all_revenue) select day, package_name, platform, idfa, idfv, user_id, all_revenue from impressions where day >= '2023-01-01' and day < yesterday();