/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 vote207 views1 answer
Except in sql alchemy
SQL
0 vote205 views2 answers
Oracle create tablespace autoextend
SQL
4 votes182 views4 answers
What is primary key
SQL
0 vote197 views1 answer
Oracle exchange subpartition
SQL
13 votes189 views6 answers
Current date sql
SQL
2 votes207 views2 answers
Sqlalchemy return id after insert
SQL
1 vote266 views1 answer
Sql select contem uma palavra
SQL
3 votes192 views1 answer
Oracle APEX elapsed time
SQL
1 vote203 views2 answers
Maximum number of tables in mysql
SQL
0 vote146 views1 answer
Check sql query executed wp
SQL