建站
咨詢(xún)
售后
建站咨詢(xún)
新聞中心
這里有您想知道的互聯(lián)網(wǎng)營(yíng)銷(xiāo)解決方案
Mysql分區(qū)表關(guān)于主鍵約束的限制
Mysql分區(qū)表對(duì)主鍵約束等都有一定的限制，下面就對(duì)Mysql5.1中Mysql分區(qū)表對(duì)于主鍵約束的限制舉例進(jìn)行說(shuō)明，供您參考學(xué)習(xí)。
關(guān)于Partitioning Keys, Primary Keys, and Unique Keys的限制：
在5.1中Mysql分區(qū)表對(duì)***約束有明確的規(guī)定，每一個(gè)***約束必須包含在Mysql分區(qū)表的分區(qū)鍵（也包括主鍵約束）。
這句話(huà)也許不好理解，我們做幾個(gè)實(shí)驗(yàn)：
- CREATE TABLE t1
- ( id INT NOT NULL,
- uid INT NOT NULL,
- PRIMARY KEY (id)
- )
- PARTITION BY RANGE (id)
- (PARTITION p0 VALUES LESS THAN(5) ENGINE = INNODB,
- PARTITION p1 VALUES LESS THAN(10) ENGINE = INNODB
- );
- CREATE TABLE t1
- ( id INT NOT NULL,
- uid INT NOT NULL,
- PRIMARY KEY (id)
- )
- PARTITION BY RANGE (id)
- (PARTITION p0 VALUES LESS THAN(5) ENGINE = MyISAM DATA DIRECTORY='/tmp'INDEX DIRECTORY='/tmp',
- PARTITION p1 VALUES LESS THAN(10) ENGINE = MyISAM DATA DIRECTORY='/tmp' INDEX DIRECTORY='/tmp'
- );
- mysql> CREATE TABLE t1
- -> ( id INT NOT NULL,
- -> uid INT NOT NULL,
- -> PRIMARY KEY (id),
- -> UNIQUE KEY (uid)
- -> )
- -> PARTITION BY RANGE (id)
- -> (PARTITION p0 VALUES LESS THAN(5),
- -> PARTITION p1 VALUES LESS THAN(10)
- -> );
- ERROR 1503 (HY000): A UNIQUE INDEX must include all columns in the table's partitioning function
【編輯推薦】
MySQL環(huán)境變量配置說(shuō)明
定義MySQL事務(wù)的例子
mysql存儲(chǔ)過(guò)程問(wèn)題解答
創(chuàng)建MySQL存儲(chǔ)過(guò)程示例
MYSQL IFNULL函數(shù)的使用
分享標(biāo)題：Mysql分區(qū)表關(guān)于主鍵約束的限制
轉(zhuǎn)載來(lái)于：http://fisionsoft.com.cn/article/dpeosdo.html
