/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 vote191 views2 answers
Mysql password error create datbase
SQL
6 votes187 views5 answers
Get current date sql
SQL
15 votes189 views2 answers
How to know the username of postgresql
SQL
0 vote193 views1 answer
If column value is null then in mysql
SQL
0 vote208 views1 answer
Sql with example
SQL
6 votes179 views1 answer
Phpmyadmin reset root password
SQL
0 vote252 views1 answer
Connect google bigquery connect using sqirrel
SQL
1 vote207 views1 answer
How to delete data from sql database in android
SQL
1 vote196 views1 answer
Alter constraint postgres
SQL
1 vote213 views1 answer
Sql server if exists update else insert
SQL