Answers for "big query add table rows to another table"

SQL

0

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`

Posted by: Guest on February-02-2022

Source

Code answers related to "big query add table rows to another table"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

C#