/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

19 votes290 views6 answers
Laravel sql query
SQL
10 votes315 views1 answer
Oracle dependencies table
SQL
1 vote305 views1 answer
Count mysql server db tables
SQL
1 vote287 views1 answer
Oracle lowercase
SQL
0 vote259 views1 answer
Oracle sysdba connect as another user
SQL
0 vote315 views2 answers
Update information in a mysql column
SQL
0 vote289 views1 answer
Soql more than today
SQL
4 votes290 views2 answers
Tables in sql
SQL
0 vote299 views1 answer
Oracle gather table statistics
SQL
0 vote251 views1 answer
Mysql select top 2
SQL