/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

1 vote98 views1 answer
Sql where last 12 months
SQL
1 vote101 views1 answer
Ilike for date postgres
SQL
0 vote118 views2 answers
Sql query print strings and int
SQL
0 vote106 views1 answer
Sql cheetsheet
SQL
0 vote104 views1 answer
How to check replication lag in mySQL
SQL
0 vote97 views1 answer
Json not contains mysql
SQL
8 votes111 views1 answer
Mysql limit rows
SQL
1 vote113 views2 answers
Check if word is in column sql
SQL
0 vote106 views1 answer
Oracle INTERVAL DAY to second to number
SQL
0 vote97 views1 answer
Sqlite explain plan
SQL