mysql - Insert Statement with result record values -

i have table 50 columns, , table has more 1 lakh records. requirement few desired records table , insert machine's database table.

is there way extract desired result records along insert statement? tried doing exporting data, fetches records.

any suggestions please?