/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

13 votes319 views3 answers
Sql online code
SQL
0 vote365 views1 answer
Sql delimiter to columns
SQL
2 votes723 views1 answer
Oracle virtual column
SQL
1 vote367 views1 answer
How to select all attributes from a row if there is a certain string in it MySQL
SQL
1 vote329 views1 answer
Oracle case
SQL
1 vote323 views1 answer
Sql oracle update multiple rows
SQL
0 vote346 views1 answer
Where date in datetime mysql
SQL
22 votes370 views3 answers
Year format in date mysql
SQL
0 vote334 views1 answer
Increase speed of like queries postgres
SQL
1 vote344 views1 answer
Change old domain to new domain name wordpress
SQL