INSERT INTO evaluation_reports (student_id, term_id, teacher_id, teacher_evaluation,student_evaluation) VALUES (46, 29, 27, 'Ozioma is a smart and intelligent student. She participates actively both class activities and extracurricular activities. She is focused, diligent, hard-working in the tasks given to her. \r\nEvidently, she is self-directed and goal-oriented.\r\nNevertheless, she is advised to curb her tendency of being loud, irritable and disruptive in class. She is encouraged to be more patient with her classmates and speak politely to them.', 'I, Mbah Maria-Faustina, have not achieved my goal yet, for there are things that I am having problem with; for example, some subjects like French, Math etc. But I hope I will  pass and get to honour roll. I have improved very well in my behaviour/ character. I just want to get to honour roll!  ') ON DUPLICATE KEY UPDATE teacher_evaluation = 'Ozioma is a smart and intelligent student. She participates actively both class activities and extracurricular activities. She is focused, diligent, hard-working in the tasks given to her. \r\nEvidently, she is self-directed and goal-oriented.\r\nNevertheless, she is advised to curb her tendency of being loud, irritable and disruptive in class. She is encouraged to be more patient with her classmates and speak politely to them.', student_evaluation = 'I, Mbah Maria-Faustina, have not achieved my goal yet, for there are things that I am having problem with; for example, some subjects like French, Math etc. But I hope I will  pass and get to honour roll. I have improved very well in my behaviour/ character. I just want to get to honour roll!  ',  teacher_id = 27 