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 vote308 views1 answer
Where date = max(date) in sql
SQL
0 vote287 views1 answer
Turn on foreign keys check mysql
SQL
3 votes278 views1 answer
Sql multiple column index
SQL
0 vote294 views1 answer
Value of sold product using having and group by in sql
SQL
3 votes339 views1 answer
What is having
SQL
16 votes305 views4 answers
Ascending order mysql
SQL
0 vote316 views2 answers
Mysql calcular idade
SQL
25 votes336 views4 answers
Import mysql dump command line
SQL
6 votes358 views2 answers
Oracle undotbs usage
SQL
0 vote353 views1 answer
Generate a random otp in sql server
SQL