mysql按天执行分区表sql_mysql按天自动生成表分区的执行语句

CREATE TABLE `jk_data` (

`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '数据ID主键',

`jk_date` datetime NOT NULL COMMENT '时间日期格式',

`jk_time` int(11) DEFAULT NULL COMMENT 'Unit格式的时间',

`jk_sn` varchar(20) DEFAULT NULL COMMENT '设备序列号SN',

`jk_counter` int(11) DEFAULT '0' COMMENT '设备计数器',

`jk_ip` varchar(50) DEFAULT NULL COMMENT '设备在网络中的ip地址',

`jk_isphysical` tinyint(2) DEFAULT '0' COMMENT '是否匹配了物理公式',

`jk_eid` tinyint(4) DEFAULT '0' COMMENT 'ID号',

`jk_wid` tinyint(2) DEFAULT '0' COMMENT '通道',

`jk_wave` int(11) DEFAULT '0' COMMENT '波长',

`jk_phyvalue` decimal(10,6) DEFAULT '0.000000' COMMENT '物理量',

`jk_serialnum` varchar(20) DEFAULT NULL COMMENT '序列号',

`jk_error` tinyint(2) DEFAULT '0' COMMENT '错误代码',

`jk_warning` tinyint(2) DEFAULT '0' COMMENT '警告代码',

PRIMARY KEY (`id`,`jk_date`) USING BTREE

) ENGINE=InnoDB AUTO_INCREMENT=304894 DEFAULT CHARSET=utf8

/*!50100 PARTITION BY RANGE (TO_DAYS(jk_date)-1)

(PARTITION jk_data20201109 VALUES LESS THAN (738103) ENGINE = InnoDB,

PARTITION jk_data20201110 VALUES LESS THAN (738104) ENGINE = InnoDB,

PARTITION jk_data20201111 VALUES LESS THAN (738105) ENGINE = InnoDB,

PARTITION jk_data20201112 VALUES LESS THAN (738106) ENGINE = InnoDB,

PARTITION jk_data20201113 VALUES LESS THAN (738107) ENGINE = InnoDB,

PARTITION jk_data20201114 VALUES LESS THAN (738108) ENGINE = InnoDB,

PARTITION jk_data20201115 VALUES LESS THAN (738109) ENGINE = InnoDB,

PARTITION jk_data20201116 VALUES LESS THAN (738110) ENGINE = InnoDB,

PARTITION jk_data20201117 VALUES LESS THAN (738111) ENGINE = InnoDB,

PARTITION jk_data20201118 VALUES LESS THAN (738112) ENGINE = InnoDB) */