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

全栈程序员-站长 • 2022年5月25日下午12:00 • 未分类 • 阅读 187

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

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

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

关于作者

全栈程序员-站长

发表回复

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

关于作者

全栈程序员-站长

相关推荐

小米手机解BL锁、线刷详细教程，适用于小米全系列手机[通俗易懂]

VS Code MCP插件生产部署必须通过的3道合规关卡（等保2.0+信创适配+审计日志闭环）

Pytest（5）美化插件进度条pytest-sugar

arcgis runtime for android 100.13.0 入门系列，一、初步引入与运行

台式计算机网线接口松动怎么办,台式电脑网卡坏了怎么修复（图文）「建议收藏」

开机就提示“请安装TCP/IP协议，error=10106”的解决的方法

发表回复