insert a select statement into a table

Solutions on MaxInterview for insert a select statement into a table by the best coders in the world

showing results for - "insert a select statement into a table"
Miguel
01 Jan 2017
1--format
2INSERT INTO Customers (CustomerName, City, Country)
3SELECT SupplierName, City, Country FROM Suppliers;
4
5--examples
6INSERT INTO Customers (CustomerName, City, Country)
7SELECT SupplierName, City, Country FROM Suppliers;