/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 vote277 views1 answer
Sqlite show columns in table
SQL
-1 vote267 views1 answer
Sql syntax create timestamp column
SQL
1 vote279 views1 answer
Select from describe sql
SQL
2 votes262 views2 answers
Oracle multiple insert
SQL
2 votes288 views1 answer
Oracle kill session by sql_id
SQL
1 vote210 views1 answer
Convert money to varchar sql server
SQL
2 votes290 views1 answer
Sql finding longest and shortest names in a fleld
SQL
0 vote282 views2 answers
Plsql regex match whole word
SQL
1 vote271 views1 answer
Oracle index partition
SQL
0 vote298 views1 answer
Oracle grant create job
SQL