/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 vote171 views1 answer
Python mysql check if database exists
SQL
1 vote158 views1 answer
Select last row from SQL Table
SQL
2 votes115 views4 answers
Check timezone of mysql database
SQL
1 vote115 views1 answer
Psql autocomplete for mac brew install
SQL
0 vote116 views1 answer
Alter precision
SQL
3 votes121 views2 answers
Order by postgresql
SQL
2 votes119 views2 answers
Laravel query builder toSql
SQL
6 votes127 views1 answer
SQL insert all columns
SQL
12 votes199 views2 answers
Find duplicates mysql column
SQL
8 votes101 views3 answers
Duplicate entry
SQL