INSERT INTO evaluation_reports (student_id, term_id, teacher_id, teacher_evaluation,student_evaluation) VALUES (8, 29, 27, 'Nathan is smart, brilliant and hard-working student. He is very conscious of his academics. His interpersonal relationship with his classmates has increased a bit. \r\nNevertheless, he is advised to shun all forms of distractions and restlessness attitude. He is encouraged to improve in his interpersonal relationship with his classmates and also organize himself. He is also encouraged to prioritized his wants in order to achieve his goals.', ' Coming into this term, as always, I was talked to by my parents and they advised me on what to do while coming into the school. I practised the advice but came up short of their expectations by getting 89%, I believe I have potentials but I do not know how to harness it. Subjects like French, Computer Studies etc., keep pulling me down, but I will keep on striving and trying to make my parents proud even though I am not on honour roll.') ON DUPLICATE KEY UPDATE teacher_evaluation = 'Nathan is smart, brilliant and hard-working student. He is very conscious of his academics. His interpersonal relationship with his classmates has increased a bit. \r\nNevertheless, he is advised to shun all forms of distractions and restlessness attitude. He is encouraged to improve in his interpersonal relationship with his classmates and also organize himself. He is also encouraged to prioritized his wants in order to achieve his goals.', student_evaluation = ' Coming into this term, as always, I was talked to by my parents and they advised me on what to do while coming into the school. I practised the advice but came up short of their expectations by getting 89%, I believe I have potentials but I do not know how to harness it. Subjects like French, Computer Studies etc., keep pulling me down, but I will keep on striving and trying to make my parents proud even though I am not on honour roll.',  teacher_id = 27 