mysql 5.7.10 表空间及多分区数据库

建表空间

CREATE TABLESPACE OR_DATA ADD DATAFILE 'OR_DATA.ibd'  ENGINE=INNODB;

在表空间上建多分区表

CREATE TABLE `ORVE` (  `TR_ID` int(11) NOT NULL  COMMENT 'ID(FK)',  `VE_ID` int(11) NOT NULL DEFAULT '0' COMMENT 'ID(FK)',  `DATA_DATE` bigint(20) NOT NULL DEFAULT '0' COMMENT '时间'  KEY `VE_ID` (`VE_ID`),  KEY `DATA_DATE` (`DATA_DATE`),  KEY `TR_ID` (`TR_ID`))TABLESPACE `OR_DATA` ENGINE=InnoDB DEFAULT CHARSET=utf8 partition by range(DATA_DATE)(    partition p20160101 values less than (20160101),    partition p20160102 values less than (20160102),    partition p20160103 values less than (20160103),    partition p20160104 values less than (20160104) );