Shulou(Shulou.com)06/02 Report--

This article mainly introduces how to open and close MySQL foreign key constraints, the article is very detailed, has a certain reference value, interested friends must read it!

When maintaining a MySQL database, it is often affected by foreign key constraints.

-- turn off foreign key constraint checking

SET @ ORIG_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0

-- enable foreign key constraint check

SET FOREIGN_KEY_CHECKS=@ORIG_FOREIGN_KEY_CHECKS

The above is all the contents of the article "how to turn MySQL foreign key constraints on and off". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.