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

1 vote329 views1 answer
Where not in array sql
SQL
8 votes292 views1 answer
Insert a select statement into a table
SQL
1 vote306 views1 answer
Mysql dump specific tables
SQL
3 votes303 views1 answer
Sql timestamp to date
SQL
0 vote315 views1 answer
Soql update query
SQL
1 vote304 views1 answer
Show per page table in xampp
SQL
1 vote315 views1 answer
Oracle grant select on schema
SQL
1 vote304 views1 answer
Order by oracle
SQL
0 vote302 views1 answer
How to user id to show in from date to upto date in mssql server
SQL
0 vote289 views1 answer
Select password from user mysql
SQL