INSERT INTO evaluation_reports (student_id, term_id, teacher_id, teacher_evaluation,student_evaluation) VALUES (101, 29, 6, 'Victory is an intelligent student, and full of life. He has the potential to carry people along and keep them happy. He carries out his activities promptly. He is in good standing with his mates. More so, his great potential can yield maximum rewards for him and the world if harnessed positively. Nevertheless, he needs to pay attention to the things that are of concern to him, like his Class Assignments and other class work.', 'The term went well for me, although I had few achievements, especially in some subjects. My set goal was to score 90% and above in all subjects, but I was unable to achieve it all, hence I intend to work harder next term. I have been able to socialize with others and my spiritual life has improved a bit.\r\nNext term, I will strive to study harder, shun all forms of distractions and aim to be in the Honour roll.') ON DUPLICATE KEY UPDATE teacher_evaluation = 'Victory is an intelligent student, and full of life. He has the potential to carry people along and keep them happy. He carries out his activities promptly. He is in good standing with his mates. More so, his great potential can yield maximum rewards for him and the world if harnessed positively. Nevertheless, he needs to pay attention to the things that are of concern to him, like his Class Assignments and other class work.', student_evaluation = 'The term went well for me, although I had few achievements, especially in some subjects. My set goal was to score 90% and above in all subjects, but I was unable to achieve it all, hence I intend to work harder next term. I have been able to socialize with others and my spiritual life has improved a bit.\r\nNext term, I will strive to study harder, shun all forms of distractions and aim to be in the Honour roll.',  teacher_id = 6 