/SQL/Sql insert multiple rows from select

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;

Similar codes

0 vote107 views1 answer
Sql server select value large text
SQL
3 votes108 views1 answer
Oracle get trigger ddl
SQL
4 votes107 views1 answer
Oracle select first 10 rows
SQL
1 vote108 views1 answer
Funzioni plsql
SQL
0 vote115 views1 answer
Get initial in sql
SQL
1 vote126 views1 answer
Oracle schema size
SQL
0 vote157 views1 answer
How to show current database in mysql
SQL
4 votes105 views1 answer
Sql query to make a existing column auto increment
SQL
0 vote141 views2 answers
Postgres isnull
SQL
6 votes113 views2 answers
What is non relational database
SQL