MySQL modifies the foreign key deletion when the operation appears error 121 How to solve

Environment: MySQL Server 5.1 + Navicat for MySQL 8.2

Problem: 121 error occurred while modifying foreign key deletion

Solve:

Change the foreign key name to another name.

Error message Reference:

Error 121

This is the name of the external keyword repetition error, even in different tables, the name of the external keyword can not be repeated.

Error 150

This type of error consists of 3 cases:

1. Foreign key and referenced foreign key types are different, such as Integer and double;

2. Unable to find the column to be referenced;

3. The character encoding of the table is different.

See more highlights of this column: http://www.bianceng.cnhttp://www.bianceng.cn/database/MySQL/