/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 vote227 views1 answer
Postgres execute multiple sql file from command line
SQL
1 vote185 views1 answer
Sql how to duplicate a table
SQL
0 vote172 views1 answer
Sqlite3 now
SQL
0 vote206 views1 answer
Comma seperated join mssql
SQL
0 vote312 views3 answers
Osx stop mysql service
SQL
3 votes209 views2 answers
Mysql select database
SQL
0 vote204 views1 answer
Sql remove non numeric characters
SQL
0 vote224 views1 answer
Node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v72-win32-x64.tar.gz
SQL
0 vote185 views3 answers
Create and attach user to a postgresql database
SQL
0 vote196 views1 answer
Sql comand for removing data from table
SQL