/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

1 vote263 views1 answer
Oracle lock user
SQL
0 vote307 views1 answer
Oracle executing sqlplus commands and waiting for completion
SQL
0 vote265 views1 answer
How should I pass a table name into a stored proc?
SQL
3 votes272 views2 answers
To_char oracle
SQL
0 vote283 views1 answer
Call scalar valued function sql
SQL
0 vote321 views1 answer
What is metadata in sql
SQL
1 vote251 views1 answer
Sql update table remove spaces
SQL
0 vote291 views1 answer
Mariadb set vertical output format
SQL
0 vote265 views1 answer
T sql check active deadlock
SQL
24 votes299 views4 answers
Postgres delete database
SQL