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 vote494 views1 answer
Postgres convert text to number
SQL
0 vote303 views1 answer
Sqlite unique multiple columns
SQL
0 vote277 views1 answer
Leftjoin in sql
SQL
4 votes243 views1 answer
Install postgres 12 on ubuntu
SQL
0 vote274 views1 answer
Nth max in my sql
SQL
0 vote281 views1 answer
How to use select union and loop
SQL
65 votes464 views6 answers
Sql add column to table
SQL
34 votes297 views5 answers
Oracle alter table add column
SQL
3 votes293 views2 answers
Search text in all sql server stored procedure
SQL
2 votes323 views3 answers
How to replace null values in sql
SQL