Partition by Key

[Vanco Josifovski]

Dear Sir/Madam,

I have the following table:

CREATE TABLE store.products (
pyear int(10) unsigned NOT NULL AUTO_INCREMENT,
pmonth int(10) unsigned NOT NULL,
pname varchar(45) COLLATE latin1_german1_ci NOT NULL,
pprice int(10) unsigned NOT NULL,
PRIMARY KEY (pyear,pmonth)
) ENGINE=MyISAM DEFAULT CHARSET latin1 COLLATE latin1_german1_ci AX_ROWS=150000000
PARTITION BY KEY(pyear,pmonth)
PARTITIONS 100;

And the folowing statement:

INSERT INTO tmp_insight.products (pyear,pmonth,pname,pprice)
VALUES (2007,1,'AJVAR',10);

Question:?

Which partition will contain my data?

I want later to say: ALTER TABLE store.products DROP PARTITION (PARTITION_NAME);

How can i find the partition_name for the data containing pyear=2007 and pmonth=1?

Thank you,

Josifovski