This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE DEFINER=`root`@`localhost` PROCEDURE `Cmonk_partition_manager`(in partition_frequency varchar(100), in db_schema varchar(100),in input_table_name varchar(100), in partition_column varchar(100)) | |
BEGIN | |
-- Author - Code Monk | |
-- Version - 1.0 | |
-- Procedure for automated partitioning of table | |
-- Inputs : | |
-- 1- Partition_frequency : Options-(Daily,Monthly,Weekly) | |
-- 2- db_schema : Name of Database schema | |
-- 3- input_table_name : Table Name |