DELETE FROM `Student` WHERE ((`student_ID` = ?) AND ((? = 1 AND `student_FirstName` IS NULL) OR (`student_FirstName` = ?)) AND ((? = 1 AND `student_LastName` IS NULL) OR (`student_LastName` = ?)) AND ((? = 1 AND `major_ID` IS NULL) OR (`major_ID` = ?)) AND ((? = 1 AND `student_Phone` IS NULL) OR (`student_Phone` = ?))) INSERT INTO `Student` (`student_ID`, `student_FirstName`, `student_LastName`, `major_ID`, `student_Phone`) VALUES (?, ?, ?, ?, ?) SELECT Student.student_ID, Student.student_FirstName, Student.student_LastName, Student.major_ID, Student.student_Phone, Department.major_Name, Department.major_Chair, Department.major_Phone FROM (Student INNER JOIN Department ON Student.major_ID = Department.major_ID) UPDATE `Student` SET `student_ID` = ?, `student_FirstName` = ?, `student_LastName` = ?, `major_ID` = ?, `student_Phone` = ? WHERE ((`student_ID` = ?) AND ((? = 1 AND `student_FirstName` IS NULL) OR (`student_FirstName` = ?)) AND ((? = 1 AND `student_LastName` IS NULL) OR (`student_LastName` = ?)) AND ((? = 1 AND `major_ID` IS NULL) OR (`major_ID` = ?)) AND ((? = 1 AND `student_Phone` IS NULL) OR (`student_Phone` = ?)))