1. 全栈程序员必看首页

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

全栈程序员-站长 • • 未分类 • 阅读 185

mysql判断表分区是否存在_mysql 分区表CREATETABLE`fs_orders_funds_detail_sp32`(`id`int(11)NOTNULLAUTO_INCREMENT,`confirm_time`datetimeNOTNULLDEFAULT’0000-00-0000:00:00′,`order_id`varchar(50)DEFAULTNULLCOMMENT’平台单号’,`updat…

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

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.net/141661.html原文链接：https://javaforall.net

赞 (0)
全栈程序员-站长的头像全栈程序员-站长
0 0


相关推荐

发表回复

您的邮箱地址不会被公开。 必填项已用 * 标注

关注全栈程序员社区公众号