title: How can I Cause a Deadlock in MySQL for Testing Purposes
body: <p>I want to make my Python library working with MySQLdb be able to detect deadlocks and try again.  I believe I've coded a good solution, and now I want to test it.</p>
  
  <p>Any ideas for the simplest queries I could run using MySQLdb to create a deadlock condition would be?</p>
  
  <p>system info:</p>
  
  <ul>
  <li>MySQL 5.0.19 </li>
  <li>Client 5.1.11 </li>
  <li>Windows XP</li>
  <li>Python 2.4 / MySQLdb 1.2.1 p2</li>
  </ul>