/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

3 votes308 views1 answer
Oracle apex message quit website
SQL
14 votes331 views2 answers
Oracle export trigger ddl
SQL
0 vote374 views1 answer
Sql basic commands
SQL
0 vote321 views1 answer
Mysql filter based on datediff
SQL
0 vote360 views1 answer
Cube oracle
SQL
0 vote343 views1 answer
In query in sql
SQL
1 vote274 views1 answer
Into sql
SQL
0 vote321 views2 answers
How to use aggregate functions in sql
SQL
0 vote376 views1 answer
PostgreSQL types and C# types
SQL
0 vote329 views1 answer
Import Data in MySQL without using any other software
SQL