/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

25 votes354 views6 answers
How to change column name in mysql
SQL
0 vote362 views1 answer
Insert value in identity
SQL
17 votes312 views6 answers
Sql current date
SQL
0 vote364 views1 answer
Java sql timestamp now
SQL
15 votes324 views2 answers
Select Options
SQL
0 vote327 views1 answer
Caused by: java.lang.RuntimeException: Unable to obtain credentials to communicate with the Cloud SQL API
SQL
1 vote334 views1 answer
Mysql query where in select
SQL
2 votes347 views1 answer
Sql server check for value in multiple columns
SQL
13 votes310 views2 answers
Oracle inner join
SQL
0 vote312 views1 answer
Sql server select ignore dupplicates
SQL