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

8 votes284 views1 answer
Oracle all_source package body
SQL
1 vote308 views3 answers
Date_add mysql
SQL
0 vote372 views1 answer
How to rename a database in tsql
SQL
0 vote324 views1 answer
Mysql where sum > 0
SQL
0 vote279 views1 answer
Mysql get last 2 month data
SQL
0 vote320 views1 answer
Change permission to database mysql
SQL
0 vote315 views1 answer
Mysql error 1114 (hy000) the table is full
SQL
0 vote313 views1 answer
Doesn't have default value mysql
SQL
0 vote295 views1 answer
Drop procedure sql
SQL
5 votes283 views2 answers
Postgre insert select
SQL