/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
Object of class sendgrid\mail\mail could not be converted to string
SQL
1 vote392 views1 answer
Sqlalchemy on delete set null
SQL
0 vote359 views1 answer
Calculate date and convert to yearsmysql
SQL
0 vote380 views1 answer
Nvl2 syntax
SQL
3 votes420 views5 answers
No module named 'MySQLdb'
SQL
8 votes406 views2 answers
How to fetch data from database without last column
SQL
0 vote344 views1 answer
Insufficient memory to excute the sql query
SQL
0 vote359 views1 answer
Sql server list user permissions
SQL
2 votes390 views3 answers
Install mysql workbench ubuntu 20.04 terminal
SQL
0 vote564 views2 answers
Create new table from existing table with data in sql server
SQL