Select inside insert query

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

#INSERT INTO table2 (column1, column2, column3, ...)
#SELECT column1, column2, column3, ...
#FROM table1
#WHERE condition;

Similar codes

0 vote171 views1 answer
Sql query to find percentage of null values in a table
SQL
14 votes139 views1 answer
Excel
SQL
8 votes137 views1 answer
Sql limit results returned
SQL
-1 vote113 views1 answer
Mysql if example
SQL
1 vote135 views1 answer
Apex ORA-20999
SQL
0 vote125 views1 answer
Materialized view redshift
SQL
50 votes199 views6 answers
Sql duplicate rows
SQL
1 vote132 views1 answer
Drop table if exists oracle
SQL
1 vote152 views2 answers
How to combine 2 tables in MySQL
SQL
0 vote151 views1 answer
Drop unique
SQL