/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 vote126 views1 answer
File /etc/init.d/mysql not exists
SQL
3 votes166 views2 answers
Create schema postgres
SQL
0 vote185 views1 answer
Sqlite3_open_v2
SQL
0 vote193 views1 answer
How to find date from date table in sql
SQL
4 votes213 views1 answer
Sql select limit range
SQL
0 vote166 views1 answer
Mysql sql select one day before
SQL
1 vote174 views1 answer
How to test for sql injection
SQL
2 votes165 views1 answer
Mysql cannot delete or update a parent row
SQL
15 votes174 views4 answers
Mysql where value is null
SQL
0 vote188 views1 answer
How to find lowest in sql
SQL