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

3 votes320 views1 answer
Show index table
SQL
7 votes326 views1 answer
Postgres base size
SQL
0 vote404 views1 answer
Why do we need data structure in sql
SQL
4 votes357 views4 answers
What is primary key
SQL
0 vote330 views1 answer
Output to file mysql
SQL
0 vote346 views1 answer
Django how to get query result count
SQL
13 votes346 views2 answers
Sql online compiler
SQL
6 votes379 views2 answers
Foreign key sqlite3 python
SQL
1 vote345 views4 answers
Sql now
SQL
0 vote366 views1 answer
Command to give readonly access to a postgres sql user
SQL