title: How to delete multiple rows with 2 columns as composite primary key in MySQL?
body: <p>My innodb table has the following structure: 4 columns <code>(CountryID, Year, %Change, Source)</code>, with the 2 columns <code>(CountryID, Year)</code> as the primary key. How do I delete multiple rows other than using a for-loop to delete each row?</p>
  
  <p>I'm looking for something similar to </p>
  
  <pre><code>DELETE FROM CPI 
   WHERE CountryID AND Year IN (('AD', 2010), ('AF', 2009), ('AG', 1992))
  </code></pre>