首頁 >資料庫 >mysql教程 >mysql5.1,5.5,5.6做partition时支持的函数_MySQL

mysql5.1,5.5,5.6做partition时支持的函数_MySQL

WBOY
WBOY原創
2016-06-01 13:04:251430瀏覽

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 <code class="literal">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 <code class="literal">TIMESTAMPcolumns) 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 <code class="literal">TIMESTAMP columns) WEEKDAY()
YEAR()   YEARWEEK()

创建partition表时,如果用了非支持函数,会出现“This partition function is not allowed”的错误提示
陳述:
本文內容由網友自願投稿,版權歸原作者所有。本站不承擔相應的法律責任。如發現涉嫌抄襲或侵權的內容,請聯絡admin@php.cn