INSERT INTO evaluation_reports (student_id, term_id, teacher_id, teacher_evaluation,student_evaluation) VALUES (32, 29, 9, 'Valour is a smart, intelligent, self-motivated student who puts forth his best effort into his classwork. He is outspoken, respectful, and happy. He sets goals for himself, and has positive optimistic attitude to life. He takes active role in class discussion and work.  He dresses neatly and likes sports and storytelling. However, he needs to work on his temper and is encouraged to learn to accept other students the way they are, take corrections and recommendations from both teachers and his peers gladly.', 'The term so far has been good for me, except for some challenges and some troubles that I experienced. My first regime average was 82%, but I have been doing much better this regime with much better scores. My goal now, is honour role, but I can get into merit role as well at the same time. I am going to try harder in the upcoming exams.') ON DUPLICATE KEY UPDATE teacher_evaluation = 'Valour is a smart, intelligent, self-motivated student who puts forth his best effort into his classwork. He is outspoken, respectful, and happy. He sets goals for himself, and has positive optimistic attitude to life. He takes active role in class discussion and work.  He dresses neatly and likes sports and storytelling. However, he needs to work on his temper and is encouraged to learn to accept other students the way they are, take corrections and recommendations from both teachers and his peers gladly.', student_evaluation = 'The term so far has been good for me, except for some challenges and some troubles that I experienced. My first regime average was 82%, but I have been doing much better this regime with much better scores. My goal now, is honour role, but I can get into merit role as well at the same time. I am going to try harder in the upcoming exams.',  teacher_id = 9 