- 当前位置：首页 >IT科技类资讯 >Mysql分区表关于主键约束的限制
Mysql分区表关于主键约束的限制
发布时间：2025-11-05 05:36:08 来源：创站工坊 作者：IT科技
复制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=/tmpINDEXDIRECTORY=/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 tables partitioning function 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30.31.
IT资讯网益华科技香港云服务器源码下载服务器租用IT技术网源码库企商汇亿华云益华IT技术论坛益强数据堂创站工坊全栈开发思维库智能时代码力社益强科技编程之道益强编程舍码上建站亿华云计算云智核亿华智造多维IT资讯益华科技益强资讯优选亿华灵动益强智未来运维纵横云站无忧益强前沿资讯极客码头益强科技益强编程堂极客编程亿华互联IT资讯网益华科技益强智囊团益强IT技术网亿华云亿华智慧云
- Copyright © 2025 Powered by Mysql分区表关于主键约束的限制,创站工坊 滇ICP备2023006006号-44sitemap