【宋词】《清平乐》 晏几道：留人不住。醉解兰舟去。一棹碧涛春水路。过尽晓莺啼处。渡头杨柳青青。枝枝叶叶离情。此後锦书休寄，画楼云雨无凭。

永夜

没有不值得去解决的问题，也没有不值得去学习的技术！

When Deleting a Table in MySQL, Error 1217 Occurs: How to Find Which Tables Reference It via Foreign Keys

When deleting a table in MySQL, an error occurs: 1217 - Cannot delete or update a parent row: a foreign key constraaint fail

作者：

永夜

在

, , , ,
Views: 55

1. When deleting a table in MySQL, an error occurs: 1217 – Cannot delete or update a parent row: a foreign key constraaint fail. See Figure 1.

When deleting a table in MySQL, an error occurs: 1217 - Cannot delete or update a parent row: a foreign key constraaint fail
Figure 1

2. Reference: You can obtain information about foreign keys from the INFORMATION_SCHEMA.KEY_COLUMN_USAGE table. It shows an example query against that table here. See Figure 2.

Reference: You can obtain information about foreign keys from the INFORMATION_SCHEMA.KEY_COLUMN_USAGE table. It shows an example query against that table here
Figure 2

3. The query results contain all foreign key information for the current connection. Locate the corresponding database, table, and field. See Figure 3.

The query results contain all foreign key information for the current connection. Locate the corresponding database, table, and field
Figure 3

4. First delete the tables corresponding to the TABLE_NAME column in the query results, and then delete this table. Deletion is successful.

关于作者 · 持续学习与技术实践

我是一名拥有 15 年以上开发经验的技术从业者，自 2013 年起持续运营个人技术博客，记录工作与个人项目中遇到的真实问题，以及解决问题过程中的探索、实践和思考。

除了技术写作，我也在持续开发和维护自己的独立项目，探索新技术和新工具在实际场景中的应用。我始终相信，没有不值得去解决的问题，也没有不值得去学习的技术。

如果这篇文章对你有所帮助，欢迎浏览博客中的其他文章，也欢迎交流技术经验与想法。

关于我  ·  GitHub  ·  邮件联系

更多文章