/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 vote195 views1 answer
Alter database datafile maxsize 32g
SQL
0 vote247 views1 answer
Insert into table with only identity column
SQL
1 vote209 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2002] Connection refused (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')
SQL
1 vote231 views1 answer
Add time to date sql
SQL
0 vote190 views1 answer
Whenever i'm passing data from datatable to sql table for large number in table it is storing with e+
SQL
0 vote190 views1 answer
Sql query to get column names and data types in sql server
SQL
14 votes193 views1 answer
Oracle new column
SQL
0 vote169 views1 answer
Mysql select statement after index
SQL
0 vote184 views1 answer
Min salary in sql
SQL
0 vote177 views1 answer
Events not working db
SQL