/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 vote162 views2 answers
Get day in sql
SQL
0 vote171 views1 answer
Where date major today mysql
SQL
0 vote162 views1 answer
Report in database
SQL
2 votes155 views2 answers
Postgresql date at timezone
SQL
0 vote156 views1 answer
Alter table fulltext
SQL
11 votes188 views1 answer
Oracle export view ddl
SQL
0 vote133 views1 answer
Mysql insert with foreign key
SQL
0 vote164 views1 answer
Starting mysql shell lampp ubuntu
SQL
1 vote159 views1 answer
User privileges postgresql information_schema
SQL
1 vote165 views1 answer
Access denied for user 'root'@'localhost' python sql-connect error
SQL