Heim >Datenbank >MySQL-Tutorial >mysql5.1,5.5,5.6做partition时支持的函数
mysql5.1,5.5,5.6做partition时支持的函数
- WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
- 2016-06-07 15:53:041820Durchsuche
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 TIMESTAMPcolumns) |
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”的错误提示
Stellungnahme：
Der Inhalt dieses Artikels wird freiwillig von Internetnutzern beigesteuert und das Urheberrecht liegt beim ursprünglichen Autor. Diese Website übernimmt keine entsprechende rechtliche Verantwortung. Wenn Sie Inhalte finden, bei denen der Verdacht eines Plagiats oder einer Rechtsverletzung besteht, wenden Sie sich bitte an admin@php.cn
Vorheriger Artikel：Mysql数据库二进制日志Nächster Artikel：mysql 主从同步设置