/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

5 votes341 views1 answer
Pl sql asynchronous procedure calls
SQL
0 vote356 views1 answer
Multiple left join mysql
SQL
-1 vote338 views1 answer
Io
SQL
12 votes355 views6 answers
Select distinct
SQL
0 vote333 views1 answer
Month mysql
SQL
0 vote327 views1 answer
SQL get max per id
SQL
0 vote383 views2 answers
Port 5432 is already in use mac
SQL
7 votes359 views2 answers
Create index mysql cli
SQL
0 vote356 views1 answer
Get null value in sql
SQL
12 votes337 views1 answer
Env var for setting password for root user mysql docker hub
SQL