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

时间：2023-03-09 04:50:18
mysql5.1,5.5,5.6做partition时支持的函数

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”的错误提示