mysql判断表分区是否存在_mysql 分区表

大家好，又见面了，我是你们的朋友全栈君。

CREATE TABLE `fs_orders_funds_detail_sp32` (

`id` int(11) NOT NULL AUTO_INCREMENT,`confirm_time` datetime NOTNULL DEFAULT ‘0000-00-00 00:00:00’,`order_id` varchar(50) DEFAULT NULL COMMENT ‘平台单号’,`update_time` timestampNULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,PRIMARYKEY (`id`,`confirm_time`),) ENGINE=InnoDB DEFAULT CHARSET=utf8/*!50100 PARTITION BY RANGE (TO_DAYS (confirm_time))

(PARTITION p_less_min VALUES LESS THAN (737425) ENGINE = InnoDB,

PARTITION p_201901 VALUES LESS THAN (737456) ENGINE = InnoDB,

PARTITION p_201902 VALUES LESS THAN (737484) ENGINE = InnoDB,

PARTITION p_201903 VALUES LESS THAN (737515) ENGINE = InnoDB,

PARTITION p_201904 VALUES LESS THAN (737545) ENGINE = InnoDB,

PARTITION p_201905 VALUES LESS THAN (737576) ENGINE = InnoDB,

PARTITION p_201906 VALUES LESS THAN (737606) ENGINE = InnoDB,

PARTITION p_201907 VALUES LESS THAN (737637) ENGINE = InnoDB,

PARTITION p_201908 VALUES LESS THAN (737668) ENGINE = InnoDB,

PARTITION p_201909 VALUES LESS THAN (737698) ENGINE = InnoDB,

PARTITION p_201910 VALUES LESS THAN (737729) ENGINE = InnoDB,

PARTITION p_201911 VALUES LESS THAN (737759) ENGINE = InnoDB,

PARTITION p_201912 VALUES LESS THAN (737790) ENGINE = InnoDB,

PARTITION p_202001 VALUES LESS THAN (737821) ENGINE = InnoDB,

PARTITION p_202002 VALUES LESS THAN (737850) ENGINE = InnoDB,

PARTITION p_202003 VALUES LESS THAN (737881) ENGINE = InnoDB,

PARTITION p_202004 VALUES LESS THAN (737911) ENGINE = InnoDB,

PARTITION p_202005 VALUES LESS THAN (737942) ENGINE = InnoDB,

PARTITION p_202006 VALUES LESS THAN (737972) ENGINE = InnoDB,

PARTITION p_202007 VALUES LESS THAN (738003) ENGINE = InnoDB,

PARTITION p_202008 VALUES LESS THAN (738034) ENGINE = InnoDB,

PARTITION p_202009 VALUES LESS THAN (738064) ENGINE = InnoDB,

PARTITION p_202010 VALUES LESS THAN (738095) ENGINE = InnoDB,

PARTITION p_202011 VALUES LESS THAN (738125) ENGINE = InnoDB,

PARTITION p_202012 VALUES LESS THAN (738156) ENGINE = InnoDB,

PARTITION p_less_max VALUES LESS THAN MAXVALUE ENGINE = InnoDB)*/;

发布者：全栈程序员栈长，转载请注明出处：https://javaforall.cn/141661.html原文链接：https://javaforall.cn