/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 votes193 views1 answer
Compare date in sql
SQL
0 vote173 views1 answer
Deny select insert update delete sql
SQL
0 vote177 views1 answer
Db format in quotation
SQL
2 votes172 views1 answer
Oracle table size
SQL
25 votes178 views3 answers
Mysql command show tables
SQL
7 votes182 views2 answers
Create index mysql cli
SQL
0 vote191 views1 answer
SQL query to verify the size of the table
SQL
12 votes216 views4 answers
How to drop all tables in postgresql
SQL
0 vote177 views1 answer
Database get 10 user aleatory
SQL
0 vote174 views1 answer
Set engine to innodb
SQL