/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

1 vote149 views1 answer
Get last week data in mysql
SQL
0 vote181 views1 answer
Order child below the parent in mysqli
SQL
0 vote153 views1 answer
How to set all the min and sec data to zero in sql server
SQL
1 vote172 views1 answer
Mysql select for update ejemplo
SQL
0 vote180 views1 answer
Arithmetic expression in sql
SQL
0 vote167 views1 answer
Mysql pv progres
SQL
9 votes168 views2 answers
Sql limit to 5 results
SQL
3 votes145 views1 answer
Oracle user quota unlimited
SQL
0 vote153 views1 answer
Sql select by content lenght
SQL
0 vote158 views2 answers
Py sqlite if entry exists
SQL