MySQL表中数据的迁移

INSERT INTO `crm_attachment`(OPERATOR_ID,ATTACHMENT_ID,TYPE ) SELECT APPLICATION_ID ,ATTACHMENT_ID,'attachmentAtrack' FROM cm_application_attachment ;