/SQL/Insert multiple rows from another table sql

Insert multiple rows from another table sql

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;

Insert multiple rows from another table sql

INSERT INTO NewTable SELECT * FROM ExistingTable;

Similar codes

1 vote221 views1 answer
Postgresql where datetrunc month and year equal
SQL
0 vote136 views1 answer
Copy table dbeaver
SQL
1 vote241 views1 answer
Cannot drop database because it is currently in use
SQL
1 vote186 views1 answer
Show indices in mysql table
SQL
0 vote165 views1 answer
Case when with count and combining similar values in sql
SQL
0 vote176 views1 answer
Qt qsql check if table exist
SQL
0 vote398 views1 answer
Power bi connect to postgresql
SQL
0 vote255 views1 answer
Sql server system messeges
SQL
27 votes217 views6 answers
Sql update record
SQL
3 votes194 views2 answers
How to delete git repo locally
SQL