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

This article mainly introduces navicat set foreign key error solution, has a certain reference value, need friends can refer to the next. I hope you will have a lot of success after reading this article. Let's take a look at it together.

Mysql uses Navicat to create foreign key error cannot add foreign key constraint, as shown below:

Solution:

(1) Check whether the field types or lengths to be associated are inconsistent.

(2) Check whether the two table codes to be associated are different.

(3) Check whether a table already has records.

(4) Set both "when deleting" and "when updating" to the same setting, such as CASCADE.

Thank you for reading this article carefully, I hope Xiaobian shares navicat set foreign key error solution content to help everyone, but also hope that everyone more support, pay attention to industry information channels, encounter problems to find, detailed solutions waiting for you to learn!

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.