집 >데이터 베이스 >MySQL 튜토리얼 >mysql5.1,5.5,5.6做partition时支持的函数
mysql5.1,5.5,5.6做partition时支持的函数
- WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB원래의
- 2016-06-07 15:53:041820검색
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”的错误提示
성명：
본 글의 내용은 네티즌들의 자발적인 기여로 작성되었으며, 저작권은 원저작자에게 있습니다. 본 사이트는 이에 상응하는 법적 책임을 지지 않습니다. 표절이나 침해가 의심되는 콘텐츠를 발견한 경우 admin@php.cn으로 문의하세요.
이전 기사：Mysql数据库二进制日志다음 기사：mysql 主从同步设置