例子:
INSERT INTO `table` (`a`, `b`, `c`, `d`, `e`) select xx1,xx2,xx3,xx4,xx5 from tableB where xxxxxx;
INSERT INTO `marker` (`second`, `mediaId`, `createdTime`, `updatedTime`, `activityId`)
select m.second,m.mediaId,m.createdTime,m.updatedTime,c.activityIdx from marker_old m join
(SELECT a.id as activityIdx,b.mediaId as fileId from activity a join activity_video b on a.mediaId = b.id and a.mediaType = 'video') c
on m.`mediaId` =c.fileId;