/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

1 vote129 views2 answers
Oracle leftmost characters
SQL
27 votes119 views4 answers
Get all tables with column name sql
SQL
0 vote126 views2 answers
How to drop mili second in sql
SQL
1 vote124 views1 answer
Error code 1292 mysql workbench
SQL
0 vote109 views1 answer
Mysql repair a table
SQL
0 vote117 views1 answer
Sql date d'aujourd'hui
SQL
5 votes131 views3 answers
DBMS_OUTPUT.PUT_LINE
SQL
0 vote114 views1 answer
Check connections to database postgres
SQL
0 vote129 views1 answer
Configure MYSQL to run on another port number, other than the default port 3306 ubuntu linux
SQL
0 vote144 views1 answer
How much space does sql server take per row
SQL