/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 vote338 views1 answer
Online sql testing tool
SQL
15 votes369 views3 answers
Postgresql change column type
SQL
0 vote380 views1 answer
Trigger vérifier stock
SQL
6 votes347 views2 answers
Mysql get yesterday
SQL
1 vote557 views2 answers
Sql unique rows
SQL
0 vote393 views1 answer
Write SQL in ruby on rails
SQL
0 vote339 views1 answer
Laravel general error 2006 mysql server has gone away
SQL
0 vote335 views1 answer
Connect postgresql using a connection string
SQL
0 vote362 views1 answer
Like sql for second letter of the family name
SQL
1 vote350 views2 answers
Test sqlsrv connection
SQL