mysql5.1,5.5,5.6做partition時支援的函數，mysql5.1partition

mysql5.1,5.5,5.6做partition時支援的函數，mysql5.1partition

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 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 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 TIMESTAMP columns)	WEEKDAY()
YEAR()		YEARWEEK()

建立partition表時，如果用了非支援函數，會出現“This partition function is not allowed”的錯誤提示