mysql 表分区创建sql_创建分区表-keyboardClicker-51CTO博客

1.使用navicat从sqlserver向MySQL中导入部分数据

select count (1) from ar_detail

2.检查导入表的建表语句

show create table ar_detail

PRIMARY KEY (`Auto_ID`),

KEY `Ar_Detail_ibvid_ind` (`iBVid`),

KEY `Ar_Detail_iflag_ind` (`iFlag`),

KEY `Ar_Detail_SY` (`cProcStyle`,`cexch_name`,`cFlag`),

KEY `Ar_cPZID` (`cPZid`),

KEY `Ar_iClosesID` (`iClosesID`),

KEY `Ar_iCoClosesID` (`iCoClosesID`),

KEY `idx_Operator_Ar_Detail` (`cOperator`),

KEY `INDEX_Ar_Detail_cCoVouchID` (`cCoVouchType`,`cCoVouchID`),

KEY `INDEX_Ar_Detail_cVouchID` (`cVouchType`,`cVouchID`),

KEY `INDEX_Ar_Detail_HX` (`cDwCode`,`cexch_name`,`cCoVouchType`),

KEY `INDEX_Ar_Detail_HXZD` (`cProcStyle`,`cCancelNo`,`cFlag`),

KEY `IX_ar_detail_Mx_MIX1` (`cFlag`,`iFlag`,`cDwCode`,`dCreditStart`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4

3.将表引擎改为innodb

alter table ar_detail engine=innodb

mysql> alter table ar_detail engine=innodb;

Query OK, 103606 rows affected (1 min 42.65 sec)

Records: 103606  Duplicates: 0  Warnings: 0

检查一下：

show create table ar_detail

修改完成

4.创建分区表

因为要测试按日期分表，接下来要对ar_detail进行dvouchdate中日期按年分区

1~创建同模式但按年分区的空表