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

来源：动视网责编：小采时间：2020-11-09 15:16:17

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

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() (seeCEILING() and FLOOR()) DAY() DAYOFMONTH() DAYOFWEEK()

推荐度：

点击下载本文 文档为doc格式

导读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() (seeCEILING() and FLOOR()) DAY() DAYOFMONTH() DAYOFWEEK()

mysql5.1支持的partition函数(http://dev.mysql.com/doc/refman/5.1/en/partitioning-limitations-functions.html) ABS() CEILING() (seeCEILING() and FLOOR()) DAY() DAYOFMONTH() DAYOFWEEK() DAYOFYEAR() DATEDIFF() EXTRACT() (seeEXTRACT() function w

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

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

推荐度：

点击下载本文 文档为doc格式

标签：支持 5.1 5.5

热门焦点

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

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

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

最新推荐

猜你喜欢

热门推荐