/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 vote110 views1 answer
Change filed order in mysql
SQL
2 votes136 views1 answer
Datefromparts mssql
SQL
0 vote104 views1 answer
Write a query to peint the pattern P(20)
SQL
0 vote109 views1 answer
Left join vs inner join performance
SQL
2 votes104 views1 answer
How to check if a row is null in sql
SQL
1 vote118 views1 answer
Import mysql dump database command line linux
SQL
0 vote109 views1 answer
Mql5 datetime get hour
SQL
0 vote108 views1 answer
Openquery update linked server
SQL
3 votes187 views4 answers
Sql interview questions
SQL
0 vote195 views1 answer
Sqlite woth cmake
SQL