/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 vote268 views1 answer
Datagrip go to line
SQL
0 vote309 views1 answer
Oracle pl/sql check if file exists
SQL
25 votes274 views6 answers
Modify column name in mysql
SQL
9 votes284 views1 answer
Alter table column change data type to text mysql
SQL
0 vote282 views1 answer
Connecting to my cloud sql server with c#
SQL
10 votes226 views2 answers
Django mysql
SQL
0 vote270 views1 answer
"SET SQL_AUTO_IS_NULL = 0" query problem
SQL
0 vote275 views1 answer
Oracle list of long running queries
SQL
0 vote267 views1 answer
How to use lower case in mysql
SQL
3 votes253 views3 answers
Mysqldump: couldn
SQL