/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

3 votes143 views1 answer
V$session not found in oracle
SQL
53 votes575 views6 answers
How to install mysql ubuntu
SQL
0 vote228 views2 answers
How to retrive image from sql to picturebox usinf image location
SQL
1 vote183 views1 answer
Sql update table remove spaces
SQL
0 vote195 views1 answer
Distance calculator from lat long sql query
SQL
5 votes201 views2 answers
Mysql create database charset utf8mb4
SQL
1 vote208 views1 answer
How to delay stored procedure execution in sql server
SQL
3 votes188 views1 answer
Make a field auto_increment mysql
SQL
3 votes193 views3 answers
Into in sql
SQL
0 vote198 views1 answer
Mysql check datetime equals date
SQL