/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 vote141 views1 answer
Convert multiple columns to ROws in sql server
SQL
0 vote120 views1 answer
Nth max in my sql
SQL
1 vote119 views1 answer
Primary key with prefix sql
SQL
1 vote113 views1 answer
Sql Split string function
SQL
0 vote128 views1 answer
Sql shell psql cannot enter password
SQL
0 vote116 views1 answer
Mysql:5.6 syntax create table
SQL
1 vote118 views1 answer
Mysql check if string contains comma separated
SQL
0 vote125 views1 answer
Object of class mysqli_result could not be converted to string
SQL
2 votes123 views1 answer
Sql update \
SQL
4 votes116 views4 answers
What is primary key
SQL