How to specify partition name while insert

[Himani Goel]

Hello Everyone,

I'm a new to partitions and have a query for which I couldn't find any answer on the internet.

I've a partitioned table, while inserting data into the table, I'm running multiple threads and hence, need to specify partition name specifically in the insert statement. But I don't know how to specify that. I understand that mysql takes care of putting the data into right partition while performing insert but is there a way to still specify the partition name in the insert statement, what wud be the syntax of that.

Thanks.