title: How to select rows from partition in MySQL
body: <p>I made partition my 300MB table and trying to make select query from <code>p0</code> partition with this command</p>
  
  <pre><code>SELECT * FROM employees PARTITION (p0);
  </code></pre>
  
  <p>But I am getting following error</p>
  
  <pre><code>ERROR 1064 (42000): You have an error in your SQL syntax; 
  check the manual that corresponds to your MySQL server version for the right syntax to use near '(p0)' at line 1
  </code></pre>
  
  <p>How to write select query to get data from specific partition?</p>