/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

4 votes254 views1 answer
To date oracle with time
SQL
1 vote257 views1 answer
Add time to date sql
SQL
1 vote267 views2 answers
Oracle list partitioned tables
SQL
7 votes271 views6 answers
Group_concat mysql
SQL
0 vote263 views1 answer
Regex mongoose
SQL
-1 vote270 views1 answer
Mysql change database charset and collation
SQL
14 votes275 views4 answers
Online sql compiler
SQL
1 vote266 views1 answer
Drop table if exists oracle
SQL
2 votes267 views5 answers
Eloquest how to select one specific column in database
SQL
0 vote266 views2 answers
Enter into postgresql database,create user and grant Access
SQL