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

This article mainly introduces navicat add foreign key error 1452 solution, the text is very detailed, has a certain reference value, interested friends must read!

If you encounter this situation, your table should have data, because the attributes in the data do not correspond.

The easiest and crudest way to solve this problem

That is, delete the data in the table and then create a foreign key on it;

If you don't have the heart to delete it, then find out the attributes that don't correspond to the two tables!

Prerequisites for creating foreign keys:

1: Whether the field of the reference table exists.

2: Component foreign key fields are required to be indexed, foreign key fields are primary keys on other tables.

3: All are innodb tables.

4: Same field type.

5: Correct syntax

In order to establish a foreign key relationship between two MySQL tables, the following three conditions must be met:

* Both tables must be of InnoDB table type. * Fields used in foreign key relationships must be of index type. Therefore, to set up index* for the field of foreign key, the two fields (fields) used in the foreign key relationship should have the same data type. The above is "navicat add foreign key error 1452 solution" all the content of this article, thank you for reading! Hope to share the content to help everyone, more relevant knowledge, welcome to pay attention to 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.