insert value into table in mysql

he INSERT INTO SELECT statement copies data from one table and inserts it into another table.

The INSERT INTO SELECT statement requires that the data types in source and target tables matches.
Syntax-
INSERT INTO table2 (column1, column2, column3, ...)
Values(value1,value2,"string",...)