本文介绍了MySQL从5.1到5.6版本中支持的分区函数，包括ABS(), CEILING(), DAY()等，并指出若使用不支持的函数将导致错误。
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”的错误提示
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
