/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

2 votes142 views4 answers
Mysql change database character set to utf8mb4
SQL
1 vote204 views1 answer
Oracle compile schema
SQL
2 votes184 views2 answers
Select list is not in group by clause
SQL
18 votes178 views4 answers
Foreign key mySql
SQL
5 votes172 views1 answer
Postgres integer to serial
SQL
0 vote191 views1 answer
How to populate a table in MySQL from and existing csv file
SQL
1 vote183 views2 answers
Change table name phpmyadmin
SQL
0 vote194 views1 answer
Access mysql database docker container shell
SQL
6 votes169 views1 answer
Phpmyadmin reset root password
SQL
11 votes174 views1 answer
Oracle view ddl
SQL