mysql错误1025(HY000):"./foo"重命名错误(错误编号:150)是什么意思? [英] What does mysql error 1025 (HY000): Error on rename of './foo' (errorno: 150) mean?

问题描述

我在mysql中尝试过:

I tried this in mysql:

mysql> alter table region drop column country_id;

得到了:

ERROR 1025 (HY000): Error on rename of './product/#sql-14ae_81' to
'./product/region' (errno: 150)

有什么想法吗?外键东西?

Any ideas? Foreign key stuff?

推荐答案

如果表使用InnoDB引擎，通常会出现此错误.在这种情况下，您将必须删除外键，然后执行alter table并删除列.

You usually get this error if your tables use the InnoDB engine. In that case you would have to drop the foreign key, and then do the alter table and drop the column.

但是，棘手的部分是您不能使用列名来删除外键，而是必须找到用于对其进行索引的名称.要找到它，请发出以下选择:

But the tricky part is that you can't drop the foreign key using the column name, but instead you would have to find the name used to index it. To find that, issue the following select:

SHOW CREATE TABLE区域；

SHOW CREATE TABLE region;

这应该向您显示索引的名称，如下所示:

This should show you the name of the index, something like this:

约束region_ibfk_1外国 关键(country_id)参考 country(id)已删除 采取行动，但不采取行动

CONSTRAINT region_ibfk_1 FOREIGN KEY (country_id) REFERENCES country (id) ON DELETE NO ACTION ON UPDATE NO ACTION

现在只需发出一个:

更改表区域放置外键 region_ibfk_1;

alter table region drop foreign key region_ibfk_1;

最后是:

更改表区域放置列 country_id;

alter table region drop column country_id;

你很好！

这篇关于mysql错误1025(HY000):"./foo"重命名错误(错误编号:150)是什么意思?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！