/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

10 votes235 views4 answers
Inner join in update query mysql
SQL
6 votes245 views1 answer
T-sql test if table exists
SQL
1 vote237 views1 answer
Show structure of table in sql
SQL
4 votes238 views2 answers
Postgre sql create table
SQL
7 votes241 views6 answers
Group_concat in mysql
SQL
0 vote219 views1 answer
How to remove default in mysql
SQL
3 votes238 views2 answers
Postgres alter table owner
SQL
0 vote236 views1 answer
Postgresql not in alternative
SQL
1 vote235 views1 answer
Select count distinct multiple columns sql server
SQL
0 vote244 views1 answer
TSQL convert csv to table
SQL