Navicat adds foreign key error 1452
- (*-*)浩Original
- 2019-08-14 11:51:079088browse
If you encounter this situation, there should be data in your table. It is because the attributes in the data do not correspond. (Recommended tutorial: navicat tutorial)
The simplest and crudest way to solve this problem
Just delete all the data in the table and then create a foreign key;
If you can’t bear to delete it, find the non-corresponding attributes in the two tables. !
Prerequisites for creating foreign keys:
1: Whether the fields of the reference table exist.
2: The fields that make up the foreign key are required to be Index and foreign key fields are primary keys in other tables.
3: Both are innodb tables.
4: The field types are the same.
5: The syntax is correct
In order to establish a foreign key relationship between two MySQL tables, the following three conditions must be met:
* 两个表必须是InnoDB表类型。 * 使用在外键关系的域（字段）必须为索引型(Index)。所以要为设置外键的字段建立index * 使用在外键关系的两个域（字段）数据类型要相同。
The above is the detailed content of Navicat adds foreign key error 1452. For more information, please follow other related articles on the PHP Chinese website!