/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 vote129 views1 answer
Get last week data in mysql
SQL
0 vote133 views1 answer
Get clob size oracle
SQL
2 votes123 views2 answers
Compare date mysql
SQL
0 vote138 views1 answer
Sql server beginning of month
SQL
6 votes139 views3 answers
Commit in sql
SQL
2 votes155 views2 answers
Python escape string for sql
SQL
1 vote149 views2 answers
Drop table with constraints
SQL
13 votes154 views2 answers
Sqlite rename table
SQL
0 vote140 views1 answer
Select year from dual oracle
SQL
0 vote155 views1 answer
Sql count total by foreign key
SQL