Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
DELIMITER // CREATE EVENT add_monthly_partition ON SCHEDULE EVERY 1 MONTH STARTS "2024-02-01 00:00:00" DO BEGIN SET @next_month = DATE_FORMAT(NOW() + INTERVAL 1 MONTH, "%Y%m01"); SET @sql = CONCAT("ALTER TABLE orders ADD PARTITION (PARTITION p", DATE_FORMAT(NOW() + INTERVAL 1 MONTH, "%Y%m"), " VALUES LESS THAN (TO_DAYS(\"", @next_month, "\")))" ); PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt; END// DELIMITER ;
Result
Open