如何在mysql中对innodb进行分区以及外键 [英] How do to partition as well as foreign key for innodb in mysql

问题描述

我想在innodb表中使用分区以及外键



i知道这不是外键的参考





我该怎么办



任何1都可以解释我

两个对我来说是必要的（同一个表上的分区和外键）

i want use partitions as well as foreign key in innodb table

i know that that is not take reference of foreign key


so what should i do

any 1 can explain me
both r necessary for me (partition as well foreign key on same table )

推荐答案

InnoDB 当前不支持用户表的外键 - 定义分区。这意味着没有用户分区的InnoDB表可能包含外键引用的外键引用或列。请阅读 [ InnoDB和FOREIGN KEY Constraints ]了解更多信息。

InnoDB does not currently support foreign keys for tables with user-defined partitioning.This means that no user-partitioned InnoDB table may contain foreign key references or columns referenced by foreign keys. Please read [ InnoDB and FOREIGN KEY Constraints] for more information.

这篇关于如何在mysql中对innodb进行分区以及外键的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！