/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

0 vote228 views1 answer
"Hello User Name"
SQL
10 votes192 views4 answers
Primary key sql
SQL
1 vote204 views1 answer
Get url of cpanel database hostname
SQL
0 vote232 views1 answer
Declare or use variable in snowflake
SQL
0 vote258 views1 answer
SCRAM authentication requires libpq version 10 or above (SQL: select * from information_schema.tables where table_schema = public and table_name = migrations and table_type = 'BASE TABLE')
SQL
1 vote202 views1 answer
Add time to date sql
SQL
0 vote215 views2 answers
How do I install microsoft SQL on my Mac?
SQL
0 vote205 views1 answer
Copy value from one column to another postgres
SQL
0 vote208 views1 answer
Greater than or equal to symbol in postgres
SQL
0 vote186 views1 answer
How to get n result in sql
SQL