/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 votes285 views1 answer
Pandas to sql index
SQL
15 votes294 views1 answer
Mysql int range
SQL
0 vote287 views1 answer
Oracle c# multiple update sql
SQL
4 votes328 views1 answer
Mysql delete last row
SQL
0 vote290 views1 answer
Oracle execute package dblink
SQL
0 vote270 views1 answer
Remove from table where
SQL
1 vote282 views2 answers
Select only columns that are not empty oracle sql
SQL
2 votes301 views1 answer
How to get non distinct values in sql
SQL
2 votes300 views1 answer
Sqlite3 show columns name
SQL
1 vote290 views1 answer
DATE_SUB postgres
SQL