MySQL foreign_key_checks是否会影响整个数据库? [英] Does MySQL foreign_key_checks affect the entire database?

问题描述

当我在MySQL中执行此命令时:

When I execute this command in MySQL:

SET FOREIGN_KEY_CHECKS=0;

它会影响整个引擎还是仅仅是我当前的交易?

Does it affect the whole engine or it is only my current transaction?

推荐答案

在设置问题方式时，它是基于会话的.

It is session-based, when set the way you did in your question.

https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html

因此，FOREIGN_KEY_CHECKS对于作用域是两个".这意味着可以将其设置为会话:

According to this, FOREIGN_KEY_CHECKS is "Both" for scope. This means it can be set for session:

SET FOREIGN_KEY_CHECKS=0;

或全局:

SET GLOBAL FOREIGN_KEY_CHECKS=0;

这篇关于MySQL foreign_key_checks是否会影响整个数据库?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！