/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

16 votes115 views6 answers
Mysql find and replace
SQL
0 vote114 views1 answer
Tsql pad left
SQL
6 votes129 views3 answers
Oracle all dates between two dates
SQL
0 vote121 views1 answer
Compare if is null sql
SQL
0 vote116 views1 answer
Change date format in oracle query
SQL
0 vote114 views1 answer
Mysql installer no packages found
SQL
8 votes108 views3 answers
Mysql alter table add index
SQL
2 votes112 views1 answer
Check isolation level in mysql
SQL
0 vote122 views1 answer
Check database restore status sql script
SQL
0 vote108 views1 answer
Sql waitfor
SQL