INSERT INTO evaluation_reports (student_id, term_id, teacher_id, teacher_evaluation,student_evaluation) VALUES (20, 29, 27, 'Confidence is a smart and brilliant student. She is outspoken and industrious. She possesses good leadership qualities. Her passion for orderliness and excellence in all of her endeavours is highly commendable. She is self-directed and goal oriented. \r\nNevertheless, she is encouraged to be more focused and pay attention to details in her academic pursuits. ', 'Though I came back a bit late, I have observed some changes, positive changes this term. Though I have not been doing well in my CEs (which resulted from coming back late) I have started following up on my academics. I now interact with the juniors, seniors and staff in this school. I know this term I did not do my best but I not only assure myself but both my parents and the school that before the end of next year, I will be on honour roll.') ON DUPLICATE KEY UPDATE teacher_evaluation = 'Confidence is a smart and brilliant student. She is outspoken and industrious. She possesses good leadership qualities. Her passion for orderliness and excellence in all of her endeavours is highly commendable. She is self-directed and goal oriented. \r\nNevertheless, she is encouraged to be more focused and pay attention to details in her academic pursuits. ', student_evaluation = 'Though I came back a bit late, I have observed some changes, positive changes this term. Though I have not been doing well in my CEs (which resulted from coming back late) I have started following up on my academics. I now interact with the juniors, seniors and staff in this school. I know this term I did not do my best but I not only assure myself but both my parents and the school that before the end of next year, I will be on honour roll.',  teacher_id = 27 