title: Can I not enforce referential integrity in MySQL
body: <p>I have a SQL table called "user" and a table "login" that has a foreign key constraint to a user.  I want to be able to delete a row in the user table, even if there are login rows that reference it.  Right now the database stops me from doing this.  </p>
  
  <p>Does anyone know how I can alter the table (through SQL or preferably through PHPmyAdmin to allow me to do this?</p>
  
  <p>The tables were created automatically through Django.</p>
  
  <p>Edit: To clarify:  I don't want to cascade the delete.  That is, I want the rows in the Login table to remain even though the user they reference is gone.  </p>