INSERT INTO evaluation_reports (student_id, term_id, teacher_id, teacher_evaluation,student_evaluation) VALUES (80, 29, 8, 'Chukwudi is a well-behaved, smart and hardworking student. His comportment in class is highly commendable. He is loved and appreciated by his mates because of his good moral values. He is an enthusiastic learner who is exhibiting a positive outlook and attitude in the classroom. He is actively involved in football. However, he needs to keep off distractions in order to enhance his academic performance.', 'The term was a bit tough for me as I struggled to perform well in my academics but I tried my best to concentrate. My relationship with others has improved, same goes for my spiritual life.\r\nAlthough I achieved some of my goals this term, but next term I want to do better, thus I have a set goal of scoring 85% and above in all subjects so I would be proud of myself.') ON DUPLICATE KEY UPDATE teacher_evaluation = 'Chukwudi is a well-behaved, smart and hardworking student. His comportment in class is highly commendable. He is loved and appreciated by his mates because of his good moral values. He is an enthusiastic learner who is exhibiting a positive outlook and attitude in the classroom. He is actively involved in football. However, he needs to keep off distractions in order to enhance his academic performance.', student_evaluation = 'The term was a bit tough for me as I struggled to perform well in my academics but I tried my best to concentrate. My relationship with others has improved, same goes for my spiritual life.\r\nAlthough I achieved some of my goals this term, but next term I want to do better, thus I have a set goal of scoring 85% and above in all subjects so I would be proud of myself.',  teacher_id = 8 