/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

9 votes278 views4 answers
Mysql show table fields
SQL
0 vote310 views1 answer
Postgresql linux password
SQL
0 vote316 views1 answer
Postgresql port 5432 not open
SQL
0 vote291 views1 answer
Limiting query result using where in sql
SQL
24 votes291 views2 answers
Alter table delete column
SQL
0 vote288 views1 answer
Postgresql regular expression special characters
SQL
0 vote317 views1 answer
How to install sql in anaconda
SQL
3 votes299 views3 answers
How to add month in update sql
SQL
1 vote344 views1 answer
Opensuse restart MySQL
SQL
15 votes291 views2 answers
Select Options
SQL