/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

4 votes131 views1 answer
Find tables with column name in sql
SQL
2 votes121 views1 answer
Mysql find tables with name
SQL
0 vote95 views1 answer
Import sql file in mysql linux
SQL
0 vote129 views1 answer
Split string by comma in sql server
SQL
0 vote132 views1 answer
Sql how to get courses that i have made prerequisites
SQL
0 vote155 views1 answer
Split first name and last name in sql
SQL
0 vote133 views1 answer
Data types mysql vs postgresql
SQL
6 votes130 views2 answers
Mysqldump password in file
SQL
0 vote127 views2 answers
Default constraint in ms sql
SQL
0 vote132 views1 answer
Mysql command prompt date insert format
SQL