INSERT INTO c_change_log_index ( change_log_row_id, video_id, type, ch, word, s,e,l, cdt) SELECT p.id, p.video_id, c.type, c.ch, c.word, c.s, c.e, c.l, c.cdt FROM c_change_log p INNER JOIN c_change_log_index c ON c.Id = p.Id