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

mysql5.1,5.5,5.6做partition时支持的函数 - mysql数据库

来源：自学PHP网时间：2015-04-16 10:50 作者：阅读:次

[导读] mysql5 1支持的partition函数 ABS()CEILING() (see CEILING() and FLOOR())DAY()DAYOFMONTH()DAYOFWEEK()DAYOFYEAR()DATEDIFF()EXTRACT() (see EXTRACT() function with W...

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

mysql存储过程及常用函数 - mysql数据库栏目 - 自学

mysql复制原理及作用分析（2014-11-11） - mysql数据库

子栏目

mysql5.1,5.5,5.6做partition时支持的函数 - mysql数据库

最新评论

添加评论

更多文章推荐

添加评论