/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

2 votes397 views1 answer
Show max_allowed_packet mysql
SQL
0 vote362 views1 answer
How change the field place in mysql
SQL
0 vote299 views1 answer
Mitigation of sql injection
SQL
1 vote306 views1 answer
Strict in postgres SQL
SQL
0 vote348 views1 answer
Postgres enumerated type
SQL
6 votes320 views1 answer
Phpmyadmin reset root password
SQL
16 votes343 views4 answers
Mysql import from sql file
SQL
0 vote346 views1 answer
Sql server delete records with specific date
SQL
0 vote326 views1 answer
Wordpress sql find and replace
SQL
0 vote378 views1 answer
Change database name psql 8
SQL