/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 vote156 views1 answer
Safe mysql
SQL
0 vote156 views1 answer
How to convert external table to managed table in hive
SQL
0 vote141 views1 answer
Oracle db timestamp auto add
SQL
3 votes140 views1 answer
Oracle list invalid password ORA-01017
SQL
3 votes138 views2 answers
Plsql print
SQL
1 vote170 views1 answer
Wordpress change url phpmyadmin
SQL
1 vote240 views1 answer
Sql injection
SQL
0 vote136 views1 answer
Add created and updatedAt fields in mysql
SQL
1 vote137 views1 answer
Apex ORA-20999
SQL
2 votes146 views2 answers
Spring where to put the data sql
SQL