/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

1 vote318 views1 answer
Insert many to many sql
SQL
0 vote274 views1 answer
How to find top 3 salary in sql
SQL
2 votes297 views1 answer
Cast string to datetime mysql
SQL
0 vote282 views1 answer
How to access to mysql without root
SQL
0 vote294 views1 answer
Mysql aspas simples
SQL
-1 vote338 views1 answer
How to Activate the database
SQL
0 vote273 views1 answer
How to solve ERROR 1049 (42000): Unknown database 'hbtn_0c_0'
SQL
14 votes292 views3 answers
Oracle sql limit results
SQL
1 vote283 views1 answer
Pv mysql import
SQL
4 votes289 views1 answer
Create db table
SQL