PHP生成MYSQL表分区语句

<?php
$sql = 'ALTER TABLE nav_master PARTITION BY RANGE(YEAR(nav_date))
SUBPARTITION BY HASH(MONTH(nav_date) ) (';
$startYear = 2019;
$endYear = 2022;
for ($y = $startYear; $y <= $endYear; $y++) {
    $yy = $y + 1;
    $sql .= " PARTITION p$y VALUES LESS THAN ($yy)
(
SUBPARTITION p" . $y . "_dec ,
SUBPARTITION p" . $y . "_jan ,
SUBPARTITION p" . $y . "_feb ,
SUBPARTITION p" . $y . "_mar ,
SUBPARTITION p" . $y . "_apr ,
SUBPARTITION p" . $y . "_may ,
SUBPARTITION p" . $y . "_jun ,
SUBPARTITION p" . $y . "_jul ,
SUBPARTITION p" . $y . "_aug ,
SUBPARTITION p" . $y . "_sep ,
SUBPARTITION p" . $y . "_oct ,
SUBPARTITION p" . $y . "_nov )";
    $sql .= ($y != $endYear) ? ',' : ')';
}
echo $sql;
?>