title: Retrieve N last rows from a mysqldump
body: <p>I'm using the following command to dump 100 rows from each column from each database. The problem is that it returns the <em>first</em> 100 records where I would much rather have the <em>last</em>. I found a flag that lets me order by primary key (--order-by-primary), but that still returns the wrong rows. I would try to sneak an 'order by' into the where flag below, but the primary key is different for each table.</p>
  
  <pre class="lang-sh prettyprint-override"><code>mysqldump -u username -p --where="true limit 100" --all-databases &gt; dump.sql
  </code></pre>
  
  <p>Is there a way to reverse the order before grabbing the last 100 records or perhaps a way of referring to the PK rather than the PK's column name?</p>