/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 votes296 views1 answer
Select a certain number of entries from select mysql
SQL
0 vote288 views3 answers
Call to undefined function mysql_connect()
SQL
0 vote265 views1 answer
How to see password mysql vestacp
SQL
4 votes262 views1 answer
Sql any
SQL
0 vote291 views1 answer
Query for backup a database at another location in file system
SQL
0 vote266 views1 answer
Longtext sql
SQL
0 vote267 views1 answer
Install mysql for fedora 34
SQL
0 vote273 views1 answer
Postgres week number
SQL
0 vote270 views1 answer
Oarcale list objects
SQL
7 votes276 views4 answers
Lowest salary in sql
SQL