/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

0 vote264 views1 answer
Show table details postgresql
SQL
9 votes262 views1 answer
No sql
SQL
1 vote249 views1 answer
Sql sort column by date
SQL
0 vote311 views1 answer
How to subquey to do not load in live database in
SQL
1 vote262 views1 answer
"i_am_a_dummy flag" in MySQL
SQL
10 votes257 views5 answers
Between keyword in sql
SQL
4 votes254 views1 answer
Force drop all tables postgres
SQL
1 vote273 views1 answer
Table valued functions in sql
SQL
7 votes253 views1 answer
Safe mode mysql
SQL
0 vote248 views1 answer
Limiting query result using where in sql
SQL