/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

5 votes248 views2 answers
Oracle show procedures
SQL
0 vote246 views1 answer
Oracle executing sqlplus commands and waiting for completion
SQL
0 vote199 views1 answer
Check duplicate values plsql
SQL
1 vote244 views1 answer
Ubuntu access database from terminal
SQL
0 vote259 views1 answer
How to rename a database in tsql
SQL
1 vote188 views1 answer
Floor function in sql oracle
SQL
0 vote199 views1 answer
Como saber si tengo mysql instalado
SQL
0 vote201 views1 answer
MQL4 mql4 run ea on all symbols by adding to just one chart
SQL
0 vote204 views1 answer
Sql cursor example multiple columns
SQL
4 votes198 views1 answer
Mysql ip address
SQL