/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

-1 vote157 views1 answer
Mysql change database charset and collation
SQL
0 vote156 views1 answer
How to check default value of column in sql server
SQL
0 vote148 views1 answer
Pl/ sql change currency
SQL
0 vote414 views1 answer
Create pl/sql stored procedure
SQL
0 vote104 views1 answer
Postgresql subquery
SQL
4 votes110 views1 answer
Oracle sleep
SQL
0 vote148 views1 answer
Multiple left join mysql
SQL
12 votes146 views1 answer
Docker mysql random root password
SQL
0 vote143 views1 answer
Postgres copy command
SQL
4 votes144 views1 answer
Mysql timestamp in laravel migration
SQL