INSERT INTO evaluation_reports (student_id, term_id, teacher_id, teacher_evaluation,student_evaluation) VALUES (29, 29, 8, 'Patrick is a smart and intelligent student. He is courageous, sociable and maintains good relationship with his classmates. He has shown improvement in his studies. However, he is encouraged to be more organized, especially with his belongings and outfit and learn to turn in his assignments and projects on time as he has the tendency of submitting late.', 'This term went smoothly as I was able to achieve some of my goals. This I did with my dogged determination to study with a pace that I set for myself. Although my goal was to score 80% and above in all subjects, I still intend to achieve it. My spiritual life has been improved a bit but I am still struggling to pray always. My relationship with others has improved a bit although I am still learning to socialize effectively and also to be organized in class.\r\nNext term, I want to do better and make my parents proud, hence, I have set a goal for myself which is to score 90% and above in all subjects.') ON DUPLICATE KEY UPDATE teacher_evaluation = 'Patrick is a smart and intelligent student. He is courageous, sociable and maintains good relationship with his classmates. He has shown improvement in his studies. However, he is encouraged to be more organized, especially with his belongings and outfit and learn to turn in his assignments and projects on time as he has the tendency of submitting late.', student_evaluation = 'This term went smoothly as I was able to achieve some of my goals. This I did with my dogged determination to study with a pace that I set for myself. Although my goal was to score 80% and above in all subjects, I still intend to achieve it. My spiritual life has been improved a bit but I am still struggling to pray always. My relationship with others has improved a bit although I am still learning to socialize effectively and also to be organized in class.\r\nNext term, I want to do better and make my parents proud, hence, I have set a goal for myself which is to score 90% and above in all subjects.',  teacher_id = 8 