INSERT INTO evaluation_reports (student_id, term_id, teacher_id, teacher_evaluation,student_evaluation) VALUES (47, 29, 8, 'Daniel is an intelligent and self-confident student. He shows considerable improvement in his academic work and that attitude is encouraged. He is a gifted footballer and enjoys conversation with friends; nevertheless, he needs to make effort to resist distractions in order to enhance his academic performance.', 'The term went well for me, even though I could not achieve my desired goal on being in the Honour roll. My relationship with others has been amazing, although I intend always to be in good term with everyone, shun malice and help others when the need arises. My spiritual life has improved too; especially with the help of the Morning Prayers and my participation during Mass. I hope to do better next term, and channel my energy into studying extensively in order to make my parents proud of me.') ON DUPLICATE KEY UPDATE teacher_evaluation = 'Daniel is an intelligent and self-confident student. He shows considerable improvement in his academic work and that attitude is encouraged. He is a gifted footballer and enjoys conversation with friends; nevertheless, he needs to make effort to resist distractions in order to enhance his academic performance.', student_evaluation = 'The term went well for me, even though I could not achieve my desired goal on being in the Honour roll. My relationship with others has been amazing, although I intend always to be in good term with everyone, shun malice and help others when the need arises. My spiritual life has improved too; especially with the help of the Morning Prayers and my participation during Mass. I hope to do better next term, and channel my energy into studying extensively in order to make my parents proud of me.',  teacher_id = 8 