MySQL表中数据的迁移


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



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