/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

1 vote171 views1 answer
Psql connect to another database
SQL
0 vote149 views1 answer
Mysql identified by syntax error
SQL
0 vote157 views2 answers
Mysql dump database tables only
SQL
0 vote154 views1 answer
Match end of string regex sql
SQL
6 votes151 views2 answers
Mysql set primary key
SQL
0 vote235 views1 answer
Sqlite send a query to a Sqlite DB with Ruby
SQL
13 votes171 views11 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysql.sock' (2) Ask
SQL
0 vote169 views1 answer
How to inner join 4 tables in sql
SQL
0 vote201 views1 answer
Month mysql
SQL
1 vote170 views1 answer
Mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists.
SQL