/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 vote180 views1 answer
Https://www.jitendrazaa.com/blog/sql/sqlserver/export-documents-saved-as-blob-binary-from-sql-server/
SQL
0 vote173 views1 answer
Désinstaller postgresql linux
SQL
7 votes187 views3 answers
Postgresql dump and restore db
SQL
1 vote170 views1 answer
Add sequence postgres
SQL
0 vote195 views1 answer
Full outer join in mariadb mysql
SQL
0 vote165 views1 answer
Install mysql for fedora 34
SQL
0 vote162 views1 answer
Postgresql regular expression special characters
SQL
0 vote170 views1 answer
SQL Query to delete all the tables in a database
SQL
8 votes186 views1 answer
Oracle search stored procedures for text
SQL
1 vote177 views1 answer
Postgresql blocked on mac
SQL