mysql>In case that you have more then few partition do drop, you can drop more partitions in one mysql row or my can drop partition one by one. This is up to you. This can be quite boring and time consuming.

Different way - fast way

This way require just list text manipulation skill.

As you know you can execute mysql command by just redirecting conf file in mysql. Syntax goes like this