/SQL/Insert multiple rows from another table sql

Insert multiple rows from another table sql

Sql insert multiple rows from select

INSERT INTO my_table SELECT * FROM source_table;
INSERT INTO my_table (a, b, c) SELECT a, b, c FROM source_table;
INSERT INTO my_table (a, b, c) SELECT a, b, c FROM source_table s
	WHERE s.my_col >= 10;

Insert multiple rows from another table sql

INSERT INTO NewTable SELECT * FROM ExistingTable;

Similar codes

3 votes139 views1 answer
V$session not found in oracle
SQL
1 vote148 views1 answer
SQl Server Versionen Releases und Build-Nummern
SQL
8 votes156 views3 answers
Find table for column name in sql
SQL
4 votes143 views1 answer
Conda install sqlalchemy
SQL
0 vote152 views1 answer
SQL joins in python
SQL
0 vote126 views1 answer
Mysql Error Code: 1005
SQL
10 votes132 views2 answers
Oracle alter sequence nextval
SQL
7 votes132 views2 answers
Mysql db size
SQL
0 vote140 views1 answer
Is there a way to use read_sql_query and the query has WHERE column = Variable?
SQL
2 votes137 views2 answers
How to rename column name in sql server using query
SQL