/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

9 votes211 views2 answers
Mysql change value
SQL
9 votes201 views3 answers
Mysql get last id
SQL
0 vote208 views1 answer
Sql select most frequent value in group
SQL
2 votes214 views1 answer
Username sql
SQL
8 votes241 views1 answer
Oracle search stored procedures for text
SQL
-1 vote217 views1 answer
Mac mysql workbench console
SQL
1 vote224 views1 answer
Mysql search like order by best match
SQL
1 vote207 views1 answer
Oracle db create new schema
SQL
0 vote237 views1 answer
Shows all databases created by user in ms sql
SQL
7 votes208 views2 answers
Add column table pl sql
SQL