Heim >Datenbank >MySQL-Tutorial >mysql5.1,5.5,5.6做partition时支持的函数_MySQL
mysql5.1,5.5,5.6做partition时支持的函数_MySQL
- WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
- 2016-06-01 13:04:251467Durchsuche
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 <code class="literal">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 <code class="literal">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 <code class="literal">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：CAPI--linux上c语言读取数据库内容（mysql）_MySQLNächster Artikel：MySQL系列：innodb引擎分析之文件IO_MySQL