/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 vote282 views1 answer
Sql server system messeges
SQL
0 vote226 views1 answer
Mysql conf.d exampel
SQL
0 vote193 views1 answer
Is not null postgresql
SQL
0 vote193 views1 answer
Mysql count grouped rows
SQL
0 vote186 views1 answer
Hibernate xml property MySQL url, username and password
SQL
16 votes216 views3 answers
MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
1 vote167 views2 answers
Delete auto increment mysql
SQL
0 vote168 views1 answer
Import csv to mysql
SQL
2 votes188 views2 answers
Oracle create table if not exists
SQL
14 votes196 views3 answers
Delete all records from table except sql
SQL