/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 vote237 views1 answer
Executescalar in sql server
SQL
3 votes259 views1 answer
Mysql insert on dupèlicate
SQL
3 votes220 views4 answers
Show sql server database
SQL
0 vote241 views1 answer
Sql server alter table column nullable
SQL
0 vote225 views1 answer
Sql count total by foreign key
SQL
1 vote220 views1 answer
Limit offset order by mysql
SQL
-1 vote249 views2 answers
Postgres autoincrement primary key
SQL
0 vote235 views1 answer
Like sql for second letter of the family name
SQL
2 votes255 views1 answer
Sql server find columns list in tables
SQL
0 vote234 views1 answer
How to check the port of mysql installation in mac
SQL