/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

2 votes254 views2 answers
Create empty table from existing table
SQL
4 votes218 views1 answer
Create column mysql terminal
SQL
0 vote245 views1 answer
Sparql if bound query
SQL
3 votes230 views1 answer
Oracle apex call duration
SQL
0 vote229 views1 answer
Sql server beginning of month
SQL
0 vote218 views1 answer
Create a PostgreSQL user django on mac
SQL
0 vote209 views1 answer
Insert or update cassandra
SQL
0 vote265 views1 answer
Table structure in sql
SQL
1 vote219 views1 answer
Stop mysql server mac
SQL
4 votes219 views1 answer
Check database name postgresql
SQL