How to get partition name of a row in mysql table

I have a table with hash partitioning. I need to find out that in which partition a specific row placed. how can I do this?

Upvotes: 0

Views: 301

Answers (1)

Finally I found the solution. This is the query:

EXPLAIN PARTITIONS SELECT * FROM table WHERE expression

Upvotes: 1

Related Questions