select from oe and insertinto another tabke with mysqlsql code example

Example: insert select

INSERT INTO table2
SELECT * FROM table1
WHERE condition;