/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 votes217 views1 answer
Oracle delete last row
SQL
1 vote218 views1 answer
How to unlock table in mysql
SQL
0 vote256 views1 answer
Sql pivot without aggregate
SQL
0 vote176 views1 answer
Store query result in variable sql
SQL
0 vote221 views1 answer
How to close external sql connection in laravel
SQL
5 votes191 views1 answer
Mongodb vs
SQL
1 vote210 views1 answer
Psql client write to bash variable
SQL
0 vote204 views1 answer
Sql offfset
SQL
0 vote245 views1 answer
Database disk image is malformed sqlite fix ubuntu
SQL
0 vote215 views1 answer
Get enginge db mysql
SQL