title: Delete a Primary Key Without Affecting Foreign Key Constrain to Other Table
body: <p>I want to delete a record from a school table without affecting a foreign key to the department name. I tried but I got this message:</p>
  
  <blockquote>
    <p>"Cannot delete or update a parent row: a foreign key constraint fails
    (<code>arusms</code>.<code>department</code>, CONSTRAINT <code>department_ibfk_1</code> FOREIGN KEY
    (<code>school_name</code>) REFERENCES <code>school</code> (<code>school_name</code>) ON UPDATE
    CASCADE)"</p>
  </blockquote>