锐客网

  1. 首页 > 睿知 > it技术 > >

mysql怎么撤销约束 mysql撤销操作( 二 )

IT技术语句


1.在定义数据项mysql怎么撤销约束的时候就声明它为主码
2.在表创建完成之后增加完整性约束
对应于1mysql怎么撤销约束 ， 撤销完整性约束
alter table employee
drop primary key;
对应于2.
alter table emloyee
drop constraint PK_eno;
PK_eno 为当初创建完整性约束时为该约束性定义mysql怎么撤销约束的名字
MYSQL如何撤销check约束？ 不要W3C里面的 ALTER TABLE Persons DROP CONSTRAINT chk_Person对于非unique索引和外键可以可以设置禁用mysql怎么撤销约束，其他mysql怎么撤销约束的，暂时还没发现 。
想要禁用非unique索引的话可以用：ALTER TABLE ... DISABLE KEYS，这个语句需要是MyISAM的表才行 。
想要禁用外键的话可以用类似下面的语句：
mysql SET foreign_key_checks = 0;
mysql SOURCE dump_file_name;
mysql SET foreign_key_checks = 1;
详细的说明，可以参考mysql文档，这里贴两段摘自MySql 5.6版的英文说明 ， 帮助理解 。
If you use ALTER TABLE on a MyISAM table, all nonunique indexes are created in a separate batch (as for REPAIR TABLE). This should make ALTER TABLEmuch faster when you have many indexes.This feature can be activated explicitly for a MyISAM table. ALTER TABLE ... DISABLE KEYS tells MySQL to stop updating nonunique indexes. ALTER TABLE ... ENABLE KEYS then should be used to re-create missing indexes. MySQL does this with a special algorithm that is much faster than inserting keys one by one, so disabling keys before performing bulk insert operations should give a considerable speedup. Using ALTER TABLE ... DISABLE KEYS requires the INDEXprivilege in addition to the privileges mentioned earlier.While the nonunique indexes are disabled, they are ignored for statements such as
SELECT and EXPLAIN that otherwise would use them.
To make it easier to reload dump files for tables that have foreign key relationships,
mysqldump automatically includes a statement in the dump output to set
foreign_key_checksto 0. This avoids problems with tables having to be reloaded in a particular order when the dump is reloaded. It is also possible to set this variable manually:mysql SET foreign_key_checks = 0;
mysql SOURCE dump_file_name;
mysql SET foreign_key_checks = 1;
This enables you to import the tables in any order if the dump file contains tables that are not correctly ordered for foreign keys. It also speeds up the import operation. Setting
foreign_key_checksto 0 can also be useful for ignoring foreign key constraints during LOAD DATAand ALTER TABLE operations. However, even ifforeign_key_checks = 0
, InnoDB does not permit the creation of a foreign key constraint where a column references a nonmatching column type. Also, if an InnoDB table has foreign key constraints,
ALTER TABLE cannot be used to change the table to use another storage engine. To alter the storage engine, drop any foreign key constraints first.
【mysql怎么撤销约束 mysql撤销操作】mysql怎么撤销约束的介绍就聊到这里吧，感谢你花时间阅读本站内容，更多关于mysql撤销操作、mysql怎么撤销约束的信息别忘了在本站进行查找喔 。

推荐阅读


上一篇：怎么导入mysql.sql，怎么导入自己动态壁纸

下一篇：java代码返回上一步，java返回上一层循环