Possible to partition on client id and year/month from timestamp?

[M Z]

Hi! Is it possible to partition on my_client_id and my_table_timestamp? I am not doing it for performance but rather the ability to archive and then delete entire partition per client id per month.

Here's a sample DDL:

CREATE TABLE `my_table` (
`my_client_id` int NOT NULL,
`my_table_id` bigint NOT NULL DEFAULT '0', -- auto increment
`my_client_location_id` int DEFAULT NULL,
`my_table_timestamp` timestamp NOT NULL
);

Many thanks in advance,