/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 vote292 views1 answer
How to select random rows from table
SQL
4 votes291 views1 answer
Oracle change nls_date_format permanently
SQL
0 vote304 views1 answer
Show table structure mysql console
SQL
0 vote298 views2 answers
Null value in column violates not-null constraint
SQL
4 votes328 views1 answer
Mysql query first character
SQL
3 votes324 views1 answer
Oracle APEX elapsed time
SQL
3 votes305 views3 answers
C# sql select
SQL
0 vote323 views1 answer
How to run mysql in git bash
SQL
1 vote296 views1 answer
Postgres count string length
SQL
0 vote295 views1 answer
Postgresql isnull with max
SQL