Bug #16818 ALTER TABLE DROP PARTITION p0, p1; is missing tables.
Submitted: 26 Jan 2006 18:50 Modified: 17 Feb 2006 13:10
Reporter: Jonathan Miller Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.1.6-alpha OS:Linux (Linux)
Assigned to: Jon Stephens CPU Architecture:Any

[26 Jan 2006 18:50] Jonathan Miller
Description:
http://dev.mysql.com/doc/refman/5.1/en/alter-table.html

 DROP PARTITION can be used to drop one or more RANGE or LIST  partitions. This command cannot be used with HASH or KEY  partitions; instead, use COALESCE PARTITION (see below). Any data that was stored in the dropped partitions named in the partition_names list is discarded. For example, given the table t1 defined previously, you can drop the partitions named p0 and p1 as shown here:

ALTER TABLE DROP PARTITION p0, p1;

ALTER TABLE table_name DROP PARTITION p0, p1;

How to repeat:
Follow link above

Suggested fix:
ALTER TABLE table_name DROP PARTITION p0, p1;
[17 Feb 2006 13:10] Jon Stephens
Thank you for your bug report. This issue has been addressed in the
documentation. The updated documentation will appear on our website
shortly, and will be included in the next release of the relevant
product(s).

Additional info:

Fixed missing table name in example.