/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

10 votes162 views2 answers
Mysql drop database if exists
SQL
0 vote146 views1 answer
Hibernate xml property MySQL url, username and password
SQL
3 votes210 views2 answers
How to list columns for particular tables in postgresql
SQL
1 vote154 views1 answer
Right outer vs left outer join
SQL
6 votes249 views3 answers
Psql show columns of table
SQL
-1 vote141 views1 answer
Extract Data from SQL Server into XML Format
SQL
0 vote203 views1 answer
Mysql faster delete
SQL
38 votes226 views4 answers
Count sql
SQL
2 votes171 views1 answer
Sql find not in list
SQL
0 vote171 views1 answer
Format the money fied with comma in international system using sql
SQL