/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

2 votes180 views1 answer
Set boolean flasksql
SQL
0 vote193 views1 answer
Transaction database with php
SQL
4 votes185 views1 answer
Alter session set nls_date_format
SQL
-1 vote178 views3 answers
Unknown collation: 'utf8mb4_0900_ai_ci'
SQL
2 votes171 views1 answer
Mysql ALTER TABLE ADD COLUMN BOOLEAN AFTER DEFAULT "1";
SQL
0 vote165 views1 answer
Change default schema sql server
SQL
1 vote173 views2 answers
How to check username in mysql command line
SQL
0 vote175 views1 answer
Kotlin sqlite delete row
SQL
0 vote194 views1 answer
Into operator in sql
SQL
0 vote198 views1 answer
Postgresql create query
SQL