/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 vote249 views1 answer
DELETE DUPLICATE VALUES FROM A TABLE IN SQL SERVER
SQL
0 vote221 views1 answer
Oracle free up space in tablespace
SQL
0 vote219 views1 answer
SQL get max per id
SQL
3 votes238 views1 answer
Postgresql today - 1 year
SQL
0 vote208 views1 answer
Low level operator in dbms
SQL
0 vote234 views1 answer
Sql check if column exists
SQL
1 vote221 views1 answer
Mysql pretty date format
SQL
1 vote231 views1 answer
Mysql view current queries
SQL
5 votes236 views6 answers
Sql foreign key
SQL
0 vote229 views1 answer
Mysql beautifier terminla
SQL