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

最新推荐文章于 2023-04-20 15:50:56 发布

cleanfield

最新推荐文章于 2023-04-20 15:50:56 发布

阅读量9.7k

点赞数 2

分类专栏： mysql 文章标签： mysql

本文链接：https://blog.csdn.net/cleanfield/article/details/41011765

版权

41 篇文章 0 订阅

订阅专栏

`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()`

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

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

关注