Home >Database >Mysql Tutorial >mysql5.1,5.5,5.6做partition时支持的函数
mysql5.1,5.5,5.6做partition时支持的函数
- WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
- 2016-06-07 15:53:041820browse
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”的错误提示
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：Mysql数据库二进制日志Next article：mysql 主从同步设置