/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 vote137 views1 answer
Mysql get first 2 characters of string
SQL
0 vote126 views1 answer
Tsql delete all rows
SQL
3 votes113 views1 answer
Postgresql if null then 0
SQL
28 votes130 views6 answers
Foreign key
SQL
0 vote122 views1 answer
Insert output identity
SQL
0 vote114 views1 answer
Show database not empty tables postgres
SQL
17 votes121 views4 answers
Mysql remove ubuntu
SQL
7 votes106 views1 answer
Sql server convert string to date
SQL
2 votes113 views1 answer
Sqlite insert if not exists
SQL
0 vote113 views1 answer
Sql value exists in column
SQL