INSERT INTO tablename1(column1,column2,column3)SELECT column1,column2,column3 from tablename2;
Login to post response