/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

1 vote172 views1 answer
How to delete a record from sqlite in android
SQL
0 vote180 views1 answer
Sql count null values in all columns
SQL
0 vote171 views2 answers
How to update date in oracle
SQL
1 vote179 views1 answer
Update foreign key value in mysql
SQL
1 vote175 views3 answers
What is union in sql
SQL
1 vote212 views1 answer
Mysql view curren querys
SQL
0 vote199 views1 answer
Sql date with year
SQL
1 vote170 views1 answer
Complete output (15 lines): /bin/sh: 1: mysql_config: not found /bin/sh: 1: mariadb_config: not found /bin/sh: 1: mysql_config: not found Traceback (most recent call last): File "<string>", line 1, in <module> File "/tmp/pi
SQL
0 vote176 views2 answers
Drop tables from local table database postgres
SQL
0 vote180 views1 answer
Select sql in descending order
SQL