/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 vote229 views1 answer
Oracle date summer time
SQL
-3 votes196 views2 answers
How to enable mysql authentication on ubuntu 18.04
SQL
-1 vote200 views2 answers
How to display top 50 rows?
SQL
0 vote203 views2 answers
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created at' in 'field list' (SQL: insert into `categories` (`category_name`, `user_id`, `created at`) values (sea fish, 1, 2021-09-24 04:17:31))
SQL
0 vote217 views1 answer
Raiserror with nowait
SQL
0 vote203 views1 answer
Print mysql
SQL
1 vote196 views1 answer
How to install mysql 8.0 windows service
SQL
0 vote208 views2 answers
Oracle select
SQL
0 vote188 views1 answer
Sql contains numeric characters
SQL
18 votes198 views6 answers
Creating table in MySQL
SQL