/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 vote198 views1 answer
Opensuse status MySQL
SQL
0 vote235 views1 answer
SQL-Arten
SQL
2 votes209 views2 answers
How to run postgresql in linux
SQL
4 votes192 views2 answers
Mysql select where starts with
SQL
2 votes190 views1 answer
How to select first row of database sql
SQL
1 vote148 views1 answer
Postgres reset auto increment
SQL
0 vote203 views1 answer
Delete record by id sql
SQL
2 votes206 views1 answer
Mysql time ago difference
SQL
0 vote209 views1 answer
Postgresql function ROUND
SQL
5 votes226 views3 answers
Day of week postgresql
SQL