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

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

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

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

        <legend id='NMgjH'><style id='NMgjH'><dir id='NMgjH'><q id='NMgjH'></q></dir></style></legend>
      1. 如何在 MySQL 中删除唯一性?

        How to drop unique in MySQL?(如何在 MySQL 中删除唯一性?)
          • <bdo id='DZPY1'></bdo><ul id='DZPY1'></ul>

              <tbody id='DZPY1'></tbody>

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

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

                  本文介绍了如何在 MySQL 中删除唯一性?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着跟版网的小编来一起学习吧!

                  问题描述

                  Create Table: CREATE TABLE `fuinfo` (
                    `fid` int(10) unsigned NOT NULL,
                    `name` varchar(40) NOT NULL,
                    `email` varchar(128) NOT NULL,
                    UNIQUE KEY `email` (`email`),
                    UNIQUE KEY `fid` (`fid`)
                  ) ENGINE=MyISAM DEFAULT CHARSET=utf8
                  

                  我想删除 email 上的唯一键,怎么办?

                  I want to drop the unique key on email,how?

                  推荐答案

                  简单的你可以使用下面的 SQL Script 来删除 MySQL 中的索引:

                  Simply you can use the following SQL Script to delete the index in MySQL:

                  alter table fuinfo drop index email;
                  

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

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

                  相关文档推荐

                  Set the variable result, from query(设置变量结果,来自查询)
                  What is dynamic SQL?(什么是动态 SQL?)
                  Mysql - How to quit/exit from stored procedure(Mysql - 如何退出/退出存储过程)
                  Does MySQL have time-based triggers?(MySQL 有基于时间的触发器吗?)
                  is it possible to call a sql script from a stored procedure in another sql script?(是否可以从另一个 sql 脚本中的存储过程调用 sql 脚本?)
                  Procedure to loop through comma separated string is not working(遍历逗号分隔字符串的过程不起作用)
                    <tbody id='iS2Lp'></tbody>
                    <bdo id='iS2Lp'></bdo><ul id='iS2Lp'></ul>
                  • <tfoot id='iS2Lp'></tfoot>

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

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