/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 vote375 views1 answer
Postgresql list extensions
SQL
0 vote335 views1 answer
Mysql select row with min date
SQL
-1 vote398 views4 answers
Full outer join in sql
SQL
0 vote368 views1 answer
Postgresql port 5432 not open
SQL
0 vote403 views1 answer
Tsql cte in a transaction
SQL
1 vote372 views1 answer
Psql view enum values
SQL
1 vote366 views1 answer
How to remove identity from a column in sql server
SQL
0 vote353 views1 answer
Sql server separar numeros por comas miles
SQL
18 votes330 views2 answers
Sql inner join
SQL
0 vote408 views1 answer
SQLSTATE[42000]: Syntax error or access violation: 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
SQL