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

2 votes177 views2 answers
HOW TO FIND MEDIAN IN SQL FOR BOTH IDD AND EVEN
SQL
0 vote145 views1 answer
Check id exist or not in sql
SQL
2 votes176 views1 answer
Q operator in sql
SQL
0 vote179 views1 answer
Find number of entries sql
SQL
1 vote199 views1 answer
Mysql datetime with timezone offset
SQL
0 vote147 views0 answer
SQL
0 vote186 views1 answer
Mysql locate
SQL
0 vote183 views1 answer
Postpresql relation not found
SQL
0 vote176 views1 answer
Postgresql extract hour and minutes from timestamp
SQL
0 vote214 views10 answers
Sql statement checker corrector
SQL