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 vote108 views1 answer
Renommer schema sql
SQL
0 vote110 views1 answer
Export partttion and import in oracle
SQL
0 vote122 views1 answer
Postgresql using reserved word as column name
SQL
0 vote112 views1 answer
Dns slave zone convert
SQL
0 vote115 views1 answer
Mariadb errno 121
SQL
0 vote113 views1 answer
How to access to mysql without root
SQL
0 vote109 views1 answer
Mysql begin statement
SQL
0 vote120 views1 answer
Change filed order in mysql
SQL
0 vote107 views1 answer
Update if else mysql
SQL
0 vote122 views1 answer
Allow external access to mysql
SQL