/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 votes265 views4 answers
Psql list tables in schema
SQL
1 vote252 views1 answer
Postgresql datetrunc too slow
SQL
0 vote245 views1 answer
Mssql describe stored procedure sqlcmd
SQL
0 vote271 views1 answer
How to check database engine in mysql
SQL
0 vote268 views1 answer
Get sum sqlite android
SQL
0 vote254 views1 answer
If column value is null then in mysql
SQL
0 vote258 views2 answers
Transaction php
SQL
0 vote253 views1 answer
Value of sold product using having and group by in sql
SQL
11 votes250 views2 answers
Mysql disable safe mode
SQL
9 votes245 views1 answer
Identity insert on sql server
SQL