INSERT INTO evaluation_reports (student_id, term_id, teacher_id, teacher_evaluation,student_evaluation) VALUES (79, 29, 8, 'Francesco is an intelligent and hardworking student. He is making steady effort to stay focused in class; nevertheless, he is encouraged to be respectful and set achievable goals of excellence. He is encouraged to refrain from collecting others students’ items, as he has the tendency of taking items without returning them.', 'The term went fine for me. I learnt whole lots of things, which in turn has transformed my mentality about reading in general. I was able to achieve some of my goals which I set as I scored 80% and above in some of the subjects. I am grateful to my teachers and hostel parents who stood beside me.\r\nMy goal for next term is to score 90% and above in all subjects, so I would be in the Honour roll. I am confident that I will achieve it.') ON DUPLICATE KEY UPDATE teacher_evaluation = 'Francesco is an intelligent and hardworking student. He is making steady effort to stay focused in class; nevertheless, he is encouraged to be respectful and set achievable goals of excellence. He is encouraged to refrain from collecting others students’ items, as he has the tendency of taking items without returning them.', student_evaluation = 'The term went fine for me. I learnt whole lots of things, which in turn has transformed my mentality about reading in general. I was able to achieve some of my goals which I set as I scored 80% and above in some of the subjects. I am grateful to my teachers and hostel parents who stood beside me.\r\nMy goal for next term is to score 90% and above in all subjects, so I would be in the Honour roll. I am confident that I will achieve it.',  teacher_id = 8 