How to select rows from partition in MySQL

Question

I made partition my 300MB table and trying to make select query from p0 partition with this command

SELECT * FROM employees PARTITION (p0);

But I am getting following error

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

How to write select query to get data from specific partition?

Answer 1

Actually since MySQL 5.6 the supported syntax is:

SELECT * FROM table PARTITION (partitionName);

Answer 2

The correct form of the query is as below it works for me fine.

select * from employees partition (`p0`);