/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 vote326 views1 answer
Postgres killing connections on db
SQL
14 votes345 views3 answers
How to add default constraint in mysql
SQL
0 vote366 views1 answer
Sql to excel pgadmin
SQL
2 votes308 views1 answer
Postgresql transaction
SQL
0 vote328 views1 answer
Oracle table free space
SQL
2 votes336 views2 answers
Mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]
SQL
0 vote311 views1 answer
Pip install mysqlclient error
SQL
1 vote336 views1 answer
Write a query to create an empty table from an existing table?
SQL
4 votes311 views1 answer
Restart for pg_hba.conf file
SQL
0 vote320 views1 answer
Mysql persistence.xml
SQL