/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

0 vote318 views1 answer
Hibernate dialect property xml for mysql 8
SQL
0 vote332 views1 answer
Query for backup a database at another location in file system
SQL
1 vote286 views1 answer
Real world example of nosql
SQL
0 vote335 views1 answer
Sql to search who modified
SQL
3 votes272 views3 answers
Print in pl sql
SQL
0 vote343 views1 answer
Duplicate table: 7 ERROR: relation "migrations" already exists (SQL: create table "migrations" ("id" serial primary key not null, "migration" varchar(255) not null, "batch" integer not null))
SQL
1 vote288 views1 answer
Apex run 404
SQL
5 votes297 views3 answers
Oracle first day of last year
SQL
0 vote314 views1 answer
ORA-13717
SQL
9 votes288 views2 answers
Mysql change value
SQL