INSERT INTO evaluation_reports (student_id, term_id, teacher_id, teacher_evaluation,student_evaluation) VALUES (123, 29, 19, 'Vanessa is a calm and respectful student. She is always attentive in class. She is organized but needs to learn to take care of her items and that of her classmates as the Class Prefect. She is encouraged to socialize, interact and assist her classmates academically.', 'Ever since I came here, G.J.C., I have noticed that not that many things have changed except just a few things in the social, moral, academic and physical aspect of life. Socially, I feel like I have actually become more open/free minded and more willing to do the needful. Morally, I have noticed that I can get easily influenced sometimes without even knowing, but when that happens and I realize it, I understand the change in my life and try to improve on it. I am very good; but when I saw my scores, I felt like crying because the highest person got 97% and I got 92% which made me very ashamed of myself. I have never imagined myself getting such a low score. But I assumed it was because of silly mistakes, that’s the part I wish to work on because it seriously affected me in primary school and I was hoping it would be different here.') ON DUPLICATE KEY UPDATE teacher_evaluation = 'Vanessa is a calm and respectful student. She is always attentive in class. She is organized but needs to learn to take care of her items and that of her classmates as the Class Prefect. She is encouraged to socialize, interact and assist her classmates academically.', student_evaluation = 'Ever since I came here, G.J.C., I have noticed that not that many things have changed except just a few things in the social, moral, academic and physical aspect of life. Socially, I feel like I have actually become more open/free minded and more willing to do the needful. Morally, I have noticed that I can get easily influenced sometimes without even knowing, but when that happens and I realize it, I understand the change in my life and try to improve on it. I am very good; but when I saw my scores, I felt like crying because the highest person got 97% and I got 92% which made me very ashamed of myself. I have never imagined myself getting such a low score. But I assumed it was because of silly mistakes, that’s the part I wish to work on because it seriously affected me in primary school and I was hoping it would be different here.',  teacher_id = 19 