/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 vote135 views1 answer
Mysql identified by syntax error
SQL
10 votes143 views3 answers
How to fetch first 5 characters in sql
SQL
10 votes135 views1 answer
Oracle view dependencies
SQL
0 vote143 views1 answer
Databricks install odbc driver connect to sql server
SQL
0 vote132 views1 answer
Mysql undo delete
SQL
0 vote135 views1 answer
Not between mysql
SQL
0 vote158 views1 answer
How convert into in in sql query
SQL
0 vote146 views1 answer
Sql use with to get value counts and percentages
SQL
0 vote196 views1 answer
How do you insert boolean to postgresql
SQL
0 vote134 views1 answer
Opensuse status MySQL
SQL