/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 vote153 views2 answers
How to find max and min salary in sql
SQL
2 votes135 views1 answer
Oracle run_duration average
SQL
0 vote142 views1 answer
Phpmyadmin tabellentyp ändern
SQL
0 vote281 views2 answers
Create new table from existing table with data in sql server
SQL
4 votes138 views4 answers
What is primary key
SQL
0 vote149 views1 answer
Add unique constraint sql server multiple columns
SQL
0 vote158 views1 answer
Mysql delete from where like
SQL
8 votes109 views1 answer
Similarities between ddl and dml
SQL
0 vote99 views1 answer
Bigquery information_schema schema all columns
SQL
10 votes150 views6 answers
Between sql
SQL