Is it possible to select and insert its result in MySQL?

I have a table that needs to be updated with another table. Can I make a Select command to insert the data foun开发者_JS百科d on another table? If so, how?

I use MySQL

---

insert into table1
(Column1, Column2)
select Column1, Column2
from table2