代碼: 選擇全部
SHOW CREATE TABLE sell_pp;
代碼: 選擇全部
CREATE TABLE `sell_pp` (
`sell_id` int(11) unsigned zerofill NOT NULL,
`date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '交易日期',
PRIMARY KEY (`sell_id`,`date`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
/*!50100 PARTITION BY RANGE (year(date))
(PARTITION p0 VALUES LESS THAN (2005) ENGINE = MyISAM,
PARTITION p1 VALUES LESS THAN (2010) ENGINE = MyISAM,
PARTITION p2 VALUES LESS THAN (2015) ENGINE = MyISAM,
PARTITION p3 VALUES LESS THAN (2020) ENGINE = MyISAM,
PARTITION p4 VALUES LESS THAN (2025) ENGINE = MyISAM,
PARTITION p5 VALUES LESS THAN MAXVALUE ENGINE = MyISAM) */ |