1. <tfoot id='zPIVl'></tfoot>
    2. <small id='zPIVl'></small><noframes id='zPIVl'>

      <i id='zPIVl'><tr id='zPIVl'><dt id='zPIVl'><q id='zPIVl'><span id='zPIVl'><b id='zPIVl'><form id='zPIVl'><ins id='zPIVl'></ins><ul id='zPIVl'></ul><sub id='zPIVl'></sub></form><legend id='zPIVl'></legend><bdo id='zPIVl'><pre id='zPIVl'><center id='zPIVl'></center></pre></bdo></b><th id='zPIVl'></th></span></q></dt></tr></i><div id='zPIVl'><tfoot id='zPIVl'></tfoot><dl id='zPIVl'><fieldset id='zPIVl'></fieldset></dl></div>

      1. <legend id='zPIVl'><style id='zPIVl'><dir id='zPIVl'><q id='zPIVl'></q></dir></style></legend>

          <bdo id='zPIVl'></bdo><ul id='zPIVl'></ul>
      2. 重命名 MySQL 中的外键列

        时间:2023-06-25

          <i id='E1UF0'><tr id='E1UF0'><dt id='E1UF0'><q id='E1UF0'><span id='E1UF0'><b id='E1UF0'><form id='E1UF0'><ins id='E1UF0'></ins><ul id='E1UF0'></ul><sub id='E1UF0'></sub></form><legend id='E1UF0'></legend><bdo id='E1UF0'><pre id='E1UF0'><center id='E1UF0'></center></pre></bdo></b><th id='E1UF0'></th></span></q></dt></tr></i><div id='E1UF0'><tfoot id='E1UF0'></tfoot><dl id='E1UF0'><fieldset id='E1UF0'></fieldset></dl></div>
          <tfoot id='E1UF0'></tfoot>

            <tbody id='E1UF0'></tbody>
        1. <legend id='E1UF0'><style id='E1UF0'><dir id='E1UF0'><q id='E1UF0'></q></dir></style></legend>

            • <bdo id='E1UF0'></bdo><ul id='E1UF0'></ul>

              <small id='E1UF0'></small><noframes id='E1UF0'>

                • 本文介绍了重命名 MySQL 中的外键列的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着跟版网的小编来一起学习吧!

                  问题描述

                  我们正在尝试重命名 MySQL (5.1.31, InnoDB) 中作为另一个表的外键的列.

                  We're trying to rename a column in MySQL (5.1.31, InnoDB) that is a foreign key to another table.

                  起初,我们尝试使用 Django-South,但遇到了一个已知问题:

                  At first, we tried to use Django-South, but came up against a known issue:

                  http://south.aeracode.org/ticket/243

                  OperationalError: (1025, "将 './xxx/#sql-bf_4d' 重命名为 './xxx/cave_event' 时出错(errno: 150)")

                  OperationalError: (1025, "Error on rename of './xxx/#sql-bf_4d' to './xxx/cave_event' (errno: 150)")

                  将./xxx/#sql-bf_4b"重命名为./xxx/cave_event"时出错(错误号:150)

                  Error on rename of './xxx/#sql-bf_4b' to './xxx/cave_event' (errno: 150)

                  此错误 150 肯定与外键约束有关.参见例如

                  This error 150 definitely pertains to foreign key constraints. See e.g.

                  什么mysql error 1025 (HY000): Error on rename of './foo' (errorno: 150) 是什么意思?

                  http://www.xaprb.com/blog/2006/08/22/mysqls-error-1025-explained/

                  所以,现在我们尝试在原始 SQL 中进行重命名.看起来我们必须先删除外键,然后进行重命名,然后再次添加外键.听起来对吗?有没有更好的方法,因为这看起来很混乱和麻烦?

                  So, now we're trying to do the renaming in raw SQL. It looks like we're going to have to drop the foreign key first, then do the rename, and then add the foreign key back again. Does that sound right? Is there a better way, since this seems pretty confusing and cumbersome?

                  任何帮助将不胜感激!

                  推荐答案

                  AFAIK,删除约束,然后重命名,然后重新添加约束是唯一的方法.先备份!

                  AFAIK, dropping the constraint, then rename, then add the constraint back is the only way. Backup first!

                  这篇关于重命名 MySQL 中的外键列的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!

                  上一篇:SELECT INTO 和“未声明的变量";错误 下一篇:如何将变量传递给 IN 子句?

                  相关文章

                  <tfoot id='xyTfs'></tfoot>

                  <legend id='xyTfs'><style id='xyTfs'><dir id='xyTfs'><q id='xyTfs'></q></dir></style></legend>
                    <bdo id='xyTfs'></bdo><ul id='xyTfs'></ul>
                • <i id='xyTfs'><tr id='xyTfs'><dt id='xyTfs'><q id='xyTfs'><span id='xyTfs'><b id='xyTfs'><form id='xyTfs'><ins id='xyTfs'></ins><ul id='xyTfs'></ul><sub id='xyTfs'></sub></form><legend id='xyTfs'></legend><bdo id='xyTfs'><pre id='xyTfs'><center id='xyTfs'></center></pre></bdo></b><th id='xyTfs'></th></span></q></dt></tr></i><div id='xyTfs'><tfoot id='xyTfs'></tfoot><dl id='xyTfs'><fieldset id='xyTfs'></fieldset></dl></div>

                  <small id='xyTfs'></small><noframes id='xyTfs'>