/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

3 votes143 views1 answer
Locate sql server
SQL
0 vote173 views1 answer
Get first monday of month sql
SQL
1 vote142 views1 answer
Select from describe sql
SQL
0 vote132 views1 answer
Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'updated_at' in 'field list'
SQL
2 votes164 views1 answer
Mysql shell insert into
SQL
5 votes139 views3 answers
Day of week postgresql
SQL
0 vote134 views2 answers
Postgres default user
SQL
0 vote143 views1 answer
Sql list dates between two dates
SQL
0 vote143 views1 answer
Raiserror with nowait
SQL
1 vote135 views1 answer
Get last week data in mysql
SQL