/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

3 votes245 views1 answer
RENAME table pl sql
SQL
0 vote201 views1 answer
Sql count * vs count 1
SQL
0 vote167 views1 answer
Online sql compiler
SQL
0 vote202 views2 answers
How to generate a unique random number in mysql
SQL
3 votes205 views1 answer
Oracle undo tablespace list by user
SQL
0 vote243 views1 answer
Selecting from a view SQL
SQL
-3 votes188 views2 answers
How to enable mysql authentication on ubuntu 18.04
SQL
17 votes195 views3 answers
Cast in sql server
SQL
5 votes190 views1 answer
Postgresql functions
SQL
8 votes205 views2 answers
Update sql server from another table
SQL