INSERT INTO evaluation_reports (student_id, term_id, teacher_id, teacher_evaluation,student_evaluation) VALUES (94, 29, 14, 'Karo is a smart, intelligent and respectful student. He is friendly and relates well with his classmates. He shows remorse and takes correction whenever he is corrected of any wrong doing. He demonstrates grit towards achieving academic excellence. He is generally good in sporting activities like sprints and football. He is the class games prefect.  \r\nHe is encouraged to keep improving on his personal cleanliness and work on his tendency to be disorganized in class.', 'My goals when I came to Gonzaga Jesuit College were;\r\n1.To have a clean streak of good behaviour. \r\n2.To be known as an honest, kind, respectful and obedient student. \r\n3.To be known for something special like sports. \r\n4.To be on the honor roll.\r\nI have achieved my goals except that of being on the honor roll. I will focus more in class, study harder and play less in order to achieve that this second regime. ') ON DUPLICATE KEY UPDATE teacher_evaluation = 'Karo is a smart, intelligent and respectful student. He is friendly and relates well with his classmates. He shows remorse and takes correction whenever he is corrected of any wrong doing. He demonstrates grit towards achieving academic excellence. He is generally good in sporting activities like sprints and football. He is the class games prefect.  \r\nHe is encouraged to keep improving on his personal cleanliness and work on his tendency to be disorganized in class.', student_evaluation = 'My goals when I came to Gonzaga Jesuit College were;\r\n1.To have a clean streak of good behaviour. \r\n2.To be known as an honest, kind, respectful and obedient student. \r\n3.To be known for something special like sports. \r\n4.To be on the honor roll.\r\nI have achieved my goals except that of being on the honor roll. I will focus more in class, study harder and play less in order to achieve that this second regime. ',  teacher_id = 14 