/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

1 vote114 views1 answer
Default
SQL
0 vote115 views2 answers
Import .sql into postgres db command
SQL
0 vote110 views1 answer
Oracle list datafiles
SQL
1 vote107 views1 answer
Delete mysql from mac
SQL
0 vote96 views1 answer
Mysql error 1452
SQL
8 votes106 views5 answers
Grant permission in postgres
SQL
0 vote111 views1 answer
Https://www.jitendrazaa.com/blog/sql/sqlserver/export-documents-saved-as-blob-binary-from-sql-server/
SQL
0 vote102 views1 answer
Sql transact create cursor with dynamic tables
SQL
0 vote109 views1 answer
Sql file in postgres with pgadmin
SQL
0 vote118 views1 answer
Mssql last day of month
SQL