56,679
社区成员
发帖
与我相关
我的任务
分享
ALTER TABLE E_info PARTITION BY RANGE( FROM_UNIXTIME(tmstmp) DIV 100000000) )
(
PARTITION p_2008_11 VALUES LESS THAN (200812),
PARTITION p_2008_12 VALUES LESS THAN (200901),
PARTITION p_2009_01 VALUES LESS THAN (200902),
PARTITION p_2009_02 VALUES LESS THAN (200903),
PARTITION p_2009_03 VALUES LESS THAN (200904),
PARTITION p_2009_04 VALUES LESS THAN (200905),
PARTITION p_2009_05 VALUES LESS THAN (200906),
PARTITION p_2009_06 VALUES LESS THAN (200907),
PARTITION p_2009_07 VALUES LESS THAN (200908),
PARTITION p_2009_08 VALUES LESS THAN (200909),
PARTITION p_catch_all VALUES LESS THAN MAXVALUE
);
mysql> select FROM_UNIXTIME(1249885811);
+---------------------------+
| FROM_UNIXTIME(1249885811) |
+---------------------------+
| 2009-08-10 14:30:11 |
+---------------------------+
1 row in set (0.00 sec)
mysql>