mysql5.1支持的partition函数(http://dev.mysql.com/doc/refman/5.1/en/partitioning-limitations-functions.html) ABS() CEILING() (seeCEILING() and FLOOR()) DAY() DAYOFMONTH() DAYOFWEEK() DAYOFYEAR() DATEDIFF() EXTRACT() (seeEXTRACT() function w
mysql5.1支持的partition函数 (http://dev.mysql.com/doc/refman/5.1/en/partitioning-limitations-functions.html)
ABS()
|
CEILING() (see CEILING()
and FLOOR()) |
DAY()
|
DAYOFMONTH()
|
DAYOFWEEK()
|
DAYOFYEAR()
|
DATEDIFF()
|
EXTRACT() (see EXTRACT()
function with WEEK specifier) |
FLOOR() (seeCEILING()
and FLOOR()) |
HOUR()
|
MICROSECOND()
|
MINUTE()
|
MOD()
|
MONTH()
|
QUARTER()
|
SECOND()
|
TIME_TO_SEC()
|
TO_DAYS()
|
UNIX_TIMESTAMP() (permitted
in MySQL 5.1.43 and later, with TIMESTAMP columns) |
WEEKDAY()
|
YEAR()
|
YEARWEEK()
|
mysql5.5支持的partition函数(http://dev.mysql.com/doc/refman/5.5/en/partitioning-limitations-functions.html)
ABS()
|
CEILING() (see CEILING()
and FLOOR()) |
DAY()
|
DAYOFMONTH()
|
DAYOFWEEK()
|
DAYOFYEAR()
|
DATEDIFF()
|
EXTRACT() (see EXTRACT()
function with WEEK specifier) |
FLOOR() (seeCEILING()
and FLOOR()) |
HOUR()
|
MICROSECOND()
|
MINUTE()
|
MOD()
|
MONTH()
|
QUARTER()
|
SECOND()
|
TIME_TO_SEC()
|
TO_DAYS()
|
TO_SECONDS()(implemented
in MySQL 5.5.0) |
UNIX_TIMESTAMP() (permitted
beginning with MySQL 5.5.1 and fully supported beginning with MySQL 5.5.15, with TIMESTAMPcolumns) |
WEEKDAY()
|
YEAR()
|
YEARWEEK()
|
mysql5.6支持的partition函数(http://dev.mysql.com/doc/refman/5.6/en/partitioning-limitations-functions.html)
ABS()
|
CEILING() (see CEILING()
and FLOOR()) |
DAY()
|
DAYOFMONTH()
|
DAYOFWEEK()
|
DAYOFYEAR()
|
DATEDIFF()
|
EXTRACT() (see EXTRACT()
function with WEEK specifier) |
FLOOR() (seeCEILING()
and FLOOR()) |
HOUR()
|
MICROSECOND()
|
MINUTE()
|
MOD()
|
MONTH()
|
QUARTER()
|
SECOND()
|
TIME_TO_SEC()
|
TO_DAYS()
|
TO_SECONDS()
|
UNIX_TIMESTAMP() (permitted
beginning with MySQL 5.6.1 and fully supported beginning with MySQL 5.6.3, with TIMESTAMP columns) |
WEEKDAY()
|
YEAR()
|
YEARWEEK()
|
创建partition表时，如果用了非支持函数，会出现“This partition function is not allowed”的错误提示
