/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 vote211 views1 answer
Sql ignore
SQL
6 votes216 views2 answers
Mysql concatenate two columns into one
SQL
1 vote217 views1 answer
Psql connect
SQL
1 vote210 views1 answer
How to ckeck that email is present in databse in mysqli
SQL
1 vote243 views2 answers
Laravel jwt generate token
SQL
4 votes211 views1 answer
Data types in sql
SQL
0 vote194 views1 answer
Create function syntax sql server
SQL
1 vote225 views3 answers
Read all columns of a table sql
SQL
3 votes212 views1 answer
Oracle user privileges
SQL
-1 vote214 views2 answers
SQL SELECT TOP Equivalent in oracal
SQL