/SQL/Sql insert multiple rows from select

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;

Similar codes

0 vote270 views2 answers
Return the number of records in a single table mysql
SQL
0 vote199 views1 answer
How to insert multiple rows in mysql using laravel
SQL
1 vote197 views1 answer
Spring postgresql reset auto increment to 0
SQL
5 votes252 views4 answers
Rollback to in sql
SQL
2 votes193 views1 answer
Wait delay in sql server
SQL
3 votes269 views1 answer
Oracle sql commit example
SQL
0 vote199 views1 answer
Sql query to force the database to be drop
SQL
0 vote209 views1 answer
Postgresql function ROUND
SQL
1 vote257 views1 answer
Sql server: difference between hashtable and table declared using declare keyword
SQL
0 vote366 views1 answer
Running mysql from bash sc
SQL