/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

13 votes114 views5 answers
Alter table query sql server change column
SQL
3 votes120 views2 answers
Find the median in sql
SQL
6 votes115 views2 answers
Find mysql version linux
SQL
2 votes124 views1 answer
Drop table if exists in postgres
SQL
16 votes130 views2 answers
Add column if not exists mysql
SQL
0 vote138 views1 answer
Oracle change password expiration policy
SQL
0 vote124 views1 answer
How many columns can be used for creating index?
SQL
0 vote130 views1 answer
Create column that already exists mysql
SQL
0 vote120 views1 answer
Oracle index hint
SQL
27 votes244 views3 answers
Mysql delete row
SQL