/SQL/Insert a select statement into a table

Insert a select statement into a table

--format
INSERT INTO Customers (CustomerName, City, Country)
SELECT SupplierName, City, Country FROM Suppliers;

--examples
INSERT INTO Customers (CustomerName, City, Country)
SELECT SupplierName, City, Country FROM Suppliers;

Similar codes

0 vote225 views1 answer
Sql count more than 1
SQL
10 votes182 views1 answer
Oracle view dependencies
SQL
0 vote235 views1 answer
Postgres meta command to show all rows in table
SQL
0 vote235 views1 answer
T sql cursor tr
SQL
0 vote220 views2 answers
Mysql regexp match word
SQL
0 vote258 views2 answers
ON DUPLICATE KEY UPDATE for postgres
SQL
1 vote224 views1 answer
Psql filed name alter
SQL
0 vote198 views1 answer
CREATE MULTIPLE FK
SQL
32 votes239 views6 answers
How to change column name in sql
SQL
0 vote221 views1 answer
Mysql replication change database name
SQL