/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 vote262 views1 answer
Postgresql check total storage
SQL
1 vote256 views1 answer
Get table which have specific columns in mysql
SQL
0 vote258 views1 answer
Oracle sql drop table
SQL
0 vote259 views1 answer
Sqlite to csv statement
SQL
7 votes262 views6 answers
Group_concat in mysql
SQL
1 vote245 views1 answer
Sample in sql
SQL
5 votes241 views1 answer
Sql first day of current year
SQL
0 vote264 views1 answer
Oracle sql log to console
SQL
0 vote250 views1 answer
Sqlite3 get data from table c
SQL
2 votes274 views1 answer
Mysql increment value by 1 in update
SQL