Functions supported by partition in mysql5.1, 5.5, and 5.6: mysql5.1partition

Functions supported by partition in mysql5.1, 5.5, and 5.6: mysql5.1partition

Partition functions supported by mysql5.1

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,TIMESTAMPColumns)	WEEKDAY()	YEAR()
	YEARWEEK()

Partition functions supported by mysql5.5

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,TIMESTAMPColumns)	WEEKDAY()
YEAR()		YEARWEEK()

Partition functions supported by mysql5.6

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,TIMESTAMPColumns)	WEEKDAY()
YEAR()		YEARWEEK()

When creating a partition table, if an unsupported function is used, the error message "This partition function is not allowed" appears.