如何使用auto_increment在游标循环中插入和更新

I have attempted looking through many of the topics already and have no success if figuring out what is wrong with my syntax. I am trying to take the distinct value of one table and loop insert into another table while the id is auto_incrementing. Here is what I have so far and I can not seem to figure out what I am doing wrong. I have 2 procedures written. They both "work" but don't. I have attempted looking through many of the to