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

0 vote367 views1 answer
Sql reverse order of results
SQL
5 votes402 views4 answers
Mysql update column with value from another table
SQL
2 votes422 views1 answer
Capitalize 1st letter in sql server
SQL
15 votes639 views2 answers
How to sort names in alphabetical order in sql
SQL
0 vote344 views1 answer
Bigquery declare
SQL
0 vote442 views1 answer
Mysql show schema
SQL
0 vote368 views1 answer
Sql server remove enter from string
SQL
1 vote367 views1 answer
Mariadb case switch
SQL
3 votes368 views1 answer
Null sql
SQL
3 votes347 views2 answers
Having in mysql
SQL