• <small id='gd6HR'></small><noframes id='gd6HR'>

  • <tfoot id='gd6HR'></tfoot>

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

        从 MySQL 表中删除唯一约束

        Dropping Unique constraint from MySQL table(从 MySQL 表中删除唯一约束)

        <small id='6HgSI'></small><noframes id='6HgSI'>

            <tbody id='6HgSI'></tbody>
              <bdo id='6HgSI'></bdo><ul id='6HgSI'></ul>
                <legend id='6HgSI'><style id='6HgSI'><dir id='6HgSI'><q id='6HgSI'></q></dir></style></legend>
              1. <tfoot id='6HgSI'></tfoot>

                1. <i id='6HgSI'><tr id='6HgSI'><dt id='6HgSI'><q id='6HgSI'><span id='6HgSI'><b id='6HgSI'><form id='6HgSI'><ins id='6HgSI'></ins><ul id='6HgSI'></ul><sub id='6HgSI'></sub></form><legend id='6HgSI'></legend><bdo id='6HgSI'><pre id='6HgSI'><center id='6HgSI'></center></pre></bdo></b><th id='6HgSI'></th></span></q></dt></tr></i><div id='6HgSI'><tfoot id='6HgSI'></tfoot><dl id='6HgSI'><fieldset id='6HgSI'></fieldset></dl></div>
                2. 本文介绍了从 MySQL 表中删除唯一约束的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着跟版网的小编来一起学习吧!

                  问题描述

                  如何使用 phpMyAdmin 在 MySQL 表的列上删除唯一键约束"?

                  How can I drop the "Unique Key Constraint" on a column of a MySQL table using phpMyAdmin?

                  推荐答案

                  唯一约束也是一个索引.

                  A unique constraint is also an index.

                  首先使用SHOW INDEX FROM tbl_name找出索引的名称.索引的名称存储在该查询结果中名为 key_name 的列中.

                  First use SHOW INDEX FROM tbl_name to find out the name of the index. The name of the index is stored in the column called key_name in the results of that query.

                  然后就可以使用DROP INDEX:

                  DROP INDEX index_name ON tbl_name
                  

                  或ALTER TABLE 语法:

                  ALTER TABLE tbl_name DROP INDEX index_name
                  

                  这篇关于从 MySQL 表中删除唯一约束的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!

                  本站部分内容来源互联网,如果有图片或者内容侵犯了您的权益,请联系我们,我们会在确认后第一时间进行删除!

                  相关文档推荐

                  Bogus foreign key constraint fail(虚假外键约束失败)
                  how to get last insert id after insert query in codeigniter active record(如何在codeigniter活动记录中插入查询后获取最后一个插入ID)
                  Force InnoDB to recheck foreign keys on a table/tables?(强制 InnoDB 重新检查表/表上的外键?)
                  How to auto generate migrations with Sequelize CLI from Sequelize models?(如何使用 Sequelize CLI 从 Sequelize 模型自动生成迁移?)
                  Clear MySQL query cache without restarting server(无需重启服务器即可清除 MySQL 查询缓存)
                  ALTER TABLE to add a composite primary key(ALTER TABLE 添加复合主键)
                    <tbody id='fdsH5'></tbody>
                  • <bdo id='fdsH5'></bdo><ul id='fdsH5'></ul>

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

                            <tfoot id='fdsH5'></tfoot>

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