/SQL/Big query add table rows to another table

Big query add table rows to another table

#standardSQL
INSERT INTO `project.dataset.copy_to_table` (id, parameter1, parameter2) 
SELECT
  id,
  parameter1,
  parameter2
FROM 
  `project.dataset.copy_from_table`
  
# For all columns
INSERT INTO `project.dataset.copy_to_table`
SELECT * FROM `project.dataset.copy_from_table`

Source: stackoverflow.com

Similar codes

0 vote113 views1 answer
Sqlite3_open_v2
SQL
5 votes119 views6 answers
In operator sql
SQL
3 votes140 views3 answers
Cannot truncate a table referenced in a foreign key constraint
SQL
10 votes103 views1 answer
Query to find object dependencies in oracle
SQL
2 votes111 views1 answer
Sql find not in list
SQL
0 vote102 views1 answer
Como hacer un select entre fechas mysql
SQL
18 votes102 views6 answers
Laravel form validation
SQL
3 votes121 views2 answers
Sql not contains
SQL
0 vote122 views1 answer
Postgresql show owner of database
SQL
0 vote108 views1 answer
Mysql installer did not find packages in the current bundle suitable for installation
SQL