/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

2 votes134 views2 answers
Sqlalchemy filter or
SQL
5 votes143 views2 answers
Create function postgresql
SQL
0 vote151 views1 answer
Last date for each user sql
SQL
1 vote171 views1 answer
Sql oracle update multiple rows
SQL
5 votes120 views2 answers
Oracle list columns schema
SQL
1 vote131 views1 answer
Drop df constraint sql server
SQL
0 vote103 views1 answer
Prevent duplicate rows in postgres
SQL
19 votes135 views6 answers
Laravel sql query
SQL
8 votes144 views1 answer
Oracle tablespace datafile max size
SQL
4 votes131 views1 answer
Sql any
SQL