/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

38 votes363 views4 answers
Count sql
SQL
1 vote345 views1 answer
User privileges postgresql information_schema
SQL
0 vote372 views3 answers
Join
SQL
13 votes333 views3 answers
Uninstall mysql centos 7
SQL
0 vote364 views1 answer
Tsql pad left
SQL
25 votes448 views5 answers
Mysql replace text
SQL
0 vote388 views1 answer
How to get one year old query from plan cache
SQL
1 vote384 views1 answer
Error cs1061 'dbcontextoptionsbuilder' does not contain a definition for 'usesqlserver'
SQL
0 vote381 views1 answer
Error: com.mysql.cj.jdbc.Driver not loaded. Are you sure you've included the correct jdbc driver in :jdbc_driver_library?
SQL
0 vote424 views1 answer
What logs are available on RDS MySQL?
SQL