首页 > 代码库 > mysql5.1,5.5,5.6做partition时支持的函数
mysql5.1,5.5,5.6做partition时支持的函数
mysql5.1支持的partition函数
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函数
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 TIMESTAMP columns) | WEEKDAY() |
YEAR() | YEARWEEK() |
mysql5.6支持的partition函数
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”的错误提示
mysql5.1,5.5,5.6做partition时支持的函数
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。