/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

13 votes128 views2 answers
Mysql order by multiple columns
SQL
2 votes146 views1 answer
Oracle drop sequence if exists
SQL
0 vote141 views1 answer
Reona
SQL
0 vote136 views1 answer
GROUP BY postgres
SQL
0 vote146 views1 answer
EnvironmentError: mysql_config not found
SQL
6 votes146 views3 answers
Date_trunc postgres
SQL
1 vote120 views1 answer
Index a database column sql
SQL
0 vote131 views1 answer
Create synonym for dblink in oracle
SQL
1 vote128 views1 answer
How to test for sql injection
SQL
0 vote170 views1 answer
How to connect to xampp sql server on windows cmd
SQL