mysql 5.1.43 開始,對timestamp 型別的分割槽有所改變
The UNIX_TIMESTAMP() function is now supported in partitioning expressions using TIMESTAMPcolumns. For example, it now possible to create a partitioned table such as this one:
CREATE TABLE t (c TIMESTAMP) PARTITION BY RANGE ( UNIX_TIMESTAMP(c) ) ( PARTITION p0 VALUES LESS THAN (631148400), PARTITION p1 VALUES LESS THAN (946681200), PARTITION p2 VALUES LESS THAN (MAXVALUE) );
All other expressions involving TIMESTAMP values are now rejected with an error when attempting to create a new partitioned table or to alter an existing partitioned table.
When accessing an existing partitioned table having a timezone-dependent partitioning function (where the table was using a previous version of MySQL), a warning rather than an error is issued. In such cases, you should fix the table. One way of doing this is to alter the table's partitioning expression so that it uses UNIX_TIMESTAMP(). (Bug #42849)
在分割槽時不能再使用to_days 等函式,只能使用unix_timestamp()函式了
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/21601207/viewspace-688754/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Mysql 的分割槽型別MySql型別
- MySQL表的四種分割槽型別MySql型別
- Windows分割槽型別Windows型別
- oracle 線上重新定義,普通表改變分割槽表,分割槽表可以更改型別、分割槽欄位等Oracle型別
- DATE型別INTERVAL分割槽型別
- mysql 資料型別TIMESTAMPMySQL 資料型別
- 範圍分割槽表和INTERVAL分割槽表對於SPLIT分割槽的區別
- MySQL 的 timestamp 和 datetime 型別比較MySql型別
- MySQL分割槽, 子分割槽以及對錄入Null值的處理情況MySqlNull
- mysql 分割槽MySql
- MySQL分割槽MySql
- Sybase的timestamp型別型別
- MySQL的分割槽(一)MySql
- MySQL的分割槽(二)MySql
- 使用split對分割槽表再分割槽
- MySQL針對Swap分割槽的運維注意點MySql運維
- MySQL8 的分割槽功能相比 mysql5.7 有什麼改進?MySql
- MySQL分割槽表的分割槽原理和優缺點MySql
- 理解MySQL分割槽MySql
- 搞懂MySQL分割槽MySql
- 【MYSQL】 分割槽表MySql
- MySql建立分割槽MySql
- MySQL 子分割槽MySql
- MySQL KEY分割槽MySql
- MySQL HASH分割槽MySql
- MySQL COLUMNS分割槽MySql
- MySQL LIST分割槽MySql
- MySQL RANGE分割槽MySql
- MySQL 分割槽表MySql
- MySQL分割槽表MySql
- mysql分割槽nullMySqlNull
- mysql 分割槽示例MySql
- oracle的timestamp型別使用Oracle型別
- TIMESTAMP型別的時區型別
- Oracle中的TIMESTAMP型別Oracle型別
- (18)mysql 中的分割槽(開發篇完)MySql
- MySQL的List分割槽表MySql
- Sybase datetime型別對映為Oracle timestamp型別Oracle