How do I correct this ('Cannot delete or update a parent row')?
<pre><code>mysql&gt; delete from faculty where fid in ( select fid from class);
</code></pre>

<blockquote>
  <p>ERROR 1451 (23000): Cannot delete or update a parent row: a foreign
  key constraint fails (<code>ass1</code>.<code>class</code>, CONSTRAINT <code>class_ibfk_1</code>
  FOREIGN KEY (<code>fid</code>) REFERENCES <code>faculty</code> (<code>fid</code>))</p>
</blockquote>

<p>This is throwing the mentioned error. What should I do?</p>