/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

2 votes336 views1 answer
Oracle percentage
SQL
0 vote341 views1 answer
Max mysql
SQL
0 vote311 views1 answer
What are the aggregate function in sql
SQL
0 vote333 views1 answer
Sql create text column limited values
SQL
2 votes417 views2 answers
Python escape string for sql
SQL
1 vote316 views1 answer
MySQL AND Operator
SQL
-1 vote370 views2 answers
Mysql get day of week
SQL
0 vote356 views1 answer
Load SQLite in Jupyter Notebook together with the access to the file
SQL
1 vote284 views1 answer
Ms sql how to see active job current run time
SQL
0 vote367 views1 answer
Google sheets data validation custom formula filter
SQL