blocks|key|1731997|text|这确实是一个外键错误，你可以使用perror来找出：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1731998|shell$+perror+150
MySQL+error+code+150:+Foreign+key+constraint+is+incorrectly+formed|code-block|syntax|javascript|1731999|要查找有关失败原因的更多详细信息，可以使用SHOW+ENGINE+INNODB+STATUS并查找最新的外键错误部分，其中包含有关错误原因的详细信息。|offset|length|style|CODE|1732000|在您的示例中，最有可能的原因是引用了country_id列。|1732001|entityMap^0|0|0|L|P|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|S|8|@$I|T|J|U|K|L]]|9|@]|A|$]]|$1|M|3|N|5|6|7|V|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

It is indeed a foreign key error, you can find out using perror:

<pre><code>shell$ perror 150
MySQL error code 150: Foreign key constraint is incorrectly formed
</code></pre>

To find out more details about what failed, you can use <code>SHOW ENGINE INNODB STATUS</code> and look for the LATEST FOREIGN KEY ERROR section it contains details about what is wrong. 

In your case, it is most likely cause something is referencing the country_id column.

blocks|key|1516996|text|尝试删除不存在的外键时也会出现此错误。因此，在删除外键时，一定要确保它们确实存在。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1516997|如果外键确实存在，并且您仍然收到此错误，请尝试以下操作：|1516998|SET+@OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS,+UNIQUE_CHECKS=0;
SET+@OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS,+FOREIGN_KEY_CHECKS=0;
SET+@OLD_SQL_MODE=@@SQL_MODE,+SQL_MODE='TRADITIONAL';|code-block|syntax|javascript|1516999|//将外键放在这里！|1517000|SET+SQL_MODE=@OLD_SQL_MODE;
SET+FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET+UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;|1517001|这对我来说总是有用的:)|1517002|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|R|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|S|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|T|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|U|8|@]|9|@]|A|$G|H]]|$1|M|3|N|5|6|7|V|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

You can get also get this error trying to drop a non-existing foreign key. So when dropping foreign keys, always make sure they actually exist.

If the foreign key does exist, and you are still getting this error try the following:

<pre><code>SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';
</code></pre>

// Drop the foreign key here!

<pre><code>SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
</code></pre>

This always does the trick for me :)

blocks|key|1517092|text|只需在drop语句中使用'KEY‘而不是'FOREIGN+KEY’运行alter+table查询。我希望这将有助于解决这个问题，并将删除外键约束，您可以更改表列和删除表。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1517093|ALTER+TABLE+slide_image_sub+DROP++KEY++FK_slide_image_sub;|code-block|syntax|javascript|1517094|这里是DROP+KEY，而不是DROP+FOREIGN+KEY，|offset|length|style|CODE|1517095|希望这能有所帮助。|1517096|谢谢|1517097|entityMap^0|0|0|3|8|F|G|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@$I|V|J|W|K|L]|$I|X|J|Y|K|L]]|9|@]|A|$]]|$1|M|3|N|5|6|7|Z|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|10|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|11|8|@]|9|@]|A|$]]]|R|$]]

Simply run the alter table query using 'KEY' instead of 'FOREIGN KEY' in the drop statement. I hope it will help to solve the issue, and will drop the foreign key constraint and you can change the table columns and drop the table.

<pre><code>ALTER TABLE slide_image_sub DROP KEY FK_slide_image_sub;
</code></pre>

here in <code>DROP KEY</code> instead of <code>DROP FOREIGN KEY</code>,

hope it will help.

Thanks

blocks|key|1517240|text|我知道，这是一个老帖子，但如果你正在寻找error+1025，它是每个人最喜欢的搜索引擎上的第一个命中。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1517241|然而，有一个简单的"hack“来解决这个问题：|1517242|在执行命令之前，首先必须使用以下命令禁用外键约束检查：|1517243|SET+FOREIGN_KEY_CHECKS+=+0;|code-block|syntax|javascript|1517244|然后你就可以执行你的命令了。|1517245|完成后，不要忘记再次启用外键约束检查，使用以下命令：|1517246|SET+FOREIGN_KEY_CHECKS+=+1;|1517247|祝你的努力好运。|1517248|entityMap^0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|V|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|W|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|X|8|@]|9|@]|A|$I|J]]|$1|K|3|L|5|6|7|Y|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|Z|8|@]|9|@]|A|$]]|$1|O|3|P|5|H|7|10|8|@]|9|@]|A|$I|J]]|$1|Q|3|R|5|6|7|11|8|@]|9|@]|A|$]]|$1|S|3|-4|5|6|7|12|8|@]|9|@]|A|$]]]|T|$]]

I know, this is an old post, but it's the first hit on everyone's favorite search engine if you are looking for error 1025.

However, there is an easy "hack" for fixing this issue:

Before you execute your command(s) you first have to disable the foreign key constraints check using this command:

<pre><code>SET FOREIGN_KEY_CHECKS = 0;
</code></pre>

Then you are able to execute your command(s).

After you are done, don't forget to enable the foreign key constraints check again, using this command:

<pre><code>SET FOREIGN_KEY_CHECKS = 1;
</code></pre>

Good luck with your endeavor.

blocks|key|1732199|text|我曾经遇到过类似的问题。我从表A中删除了主键，但是当我试图从表B中删除外键列时，显示了上述相同的错误。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1732200|不能使用列名删除外键，要在PHPMyAdmin或with+MySQL中绕过此操作，请先删除外键约束，然后再重命名或删除属性。|1732201|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

I had a similar issues once. I deleted the primary key from TABLE A but when I was trying to delete the foreign key column from table B I was shown the above same error.

You can't drop the foreign key using the column name and to bypass this in PHPMyAdmin or with MySQL, first remove the foreign key constraint before renaming or deleting the attribute.

blocks|key|1517035|text|查看mysql数据库的错误文件。根据Bug+#26305的说法，我的sql不会给出原因。此错误从MySQL+4.1开始存在;-)|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1517036|entityMap|0|LINK|mutability|MUTABLE|url|http://bugs.mysql.com/bug.php?id=26305^0|I|A|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

Take a look in error file for your mysql database. According to <a href="http://bugs.mysql.com/bug.php?id=26305" rel="nofollow noreferrer">Bug #26305</a> my sql do not give you the cause. This bug exists since MySQL 4.1 ;-)

blocks|key|1732102|text|如果您使用的是像MySQL工作台这样的客户机，请右键单击要从中删除外键的所需表，然后选择外键选项卡并删除索引。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1732103|然后，您可以像这样运行查询：|1732104|alter+table+table_name+drop+foreign_key_col_name;|code-block|syntax|javascript|1732105|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|L|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|M|8|@]|9|@]|A|$G|H]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

If you are using a client like MySQL Workbench, right click the desired table from where a foreign key is to be deleted, then select the foreign key tab and delete the indexes.

Then you can run the query like this:

<pre><code>alter table table_name drop foreign_key_col_name;
</code></pre>

blocks|key|1732156|text|可能有另一个表具有引用您试图更改的主键的外键。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1732157|要找出是哪个表导致了错误，可以运行SHOW+ENGINE+INNODB+STATUS，然后查看LATEST+FOREIGN+KEY+ERROR部分|offset|length|style|CODE|1732158|使用SHOW+CREATE+TABLE+categories显示约束的名称。|1732159|最有可能的是categories_ibfk_1|1732160|首先使用名称删除外键，然后删除列：|1732161|ALTER+TABLE+categories+DROP+FOREIGN+KEY+categories_ibfk_1;
ALTER+TABLE+categories+DROP+COLUMN+assets_id;|code-block|syntax|javascript|1732162|entityMap^0|0|H|I|10|6|1B|O|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|V|8|@$D|W|E|X|F|G]|$D|Y|E|Z|F|G]|$D|10|E|11|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|12|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|13|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|14|8|@]|9|@]|A|$]]|$1|N|3|O|5|P|7|15|8|@]|9|@]|A|$Q|R]]|$1|S|3|-4|5|6|7|16|8|@]|9|@]|A|$]]]|T|$]]

There is probably another table with a foreign key referencing the primary key you are trying to change.

To find out which table caused the error you can run <code>SHOW ENGINE INNODB</code> <code>STATUS</code> and then look at the <code>LATEST FOREIGN KEY ERROR</code> section

Use SHOW CREATE TABLE categories to show the name of constraint.

Most probably it will be categories_ibfk_1

Use the name to drop the foreign key first and the column then:

<pre><code>ALTER TABLE categories DROP FOREIGN KEY categories_ibfk_1;
ALTER TABLE categories DROP COLUMN assets_id;
</code></pre>

blocks|key|1732282|text|正在做什么|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1732283|SET+FOREIGN_KEY_CHECKS=0;|code-block|syntax|javascript|1732284|之前的操作也可以做到这一点。|1732285|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

Doing

<pre><code>SET FOREIGN_KEY_CHECKS=0;
</code></pre>

before the Operation can also do the trick.

blocks|key|1516891|text|我猜是外键约束问题。country_id是否在另一个表中用作外键？|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1516892|我不是DB专家，但我认为我通过删除fk，执行我的alter+table内容，然后重做fk内容，解决了类似这样的问题(存在fk约束)。|1516893|我很想知道结果是什么--有时候mysql是相当神秘的。|1516894|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

I'd guess foreign key constraint problem. Is country_id used as a foreign key in another table?

I'm not DB guru but I think I solved a problem like this (where there was a fk constraint) by removing the fk, doing my alter table stuff and then redoing the fk stuff.

I'll be interested to hear what the outcome is - sometime mysql is pretty cryptic.

blocks|key|1732392|text|我在MySQL+5.6中得到了这个错误，但它与外键无关。这是在一台Windows+7专业版计算机上，充当小型LAN上的服务器。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1732393|客户端应用程序正在执行一个批处理操作，该操作创建一个表，用一些外部数据填充它，然后运行一个与永久表连接的查询，然后删除“临时”表。这个批处理大约做了300次，这个特定的例程已经一周又一周地运行了几年，突然我们得到了错误1025，无法在批处理中的任意点重命名问题。|1732394|在我的例子中，应用程序使用4条DDL语句，一个CREATE+TABLE后跟3个CREATE+INDEX，没有外键。但是，实际创建的索引只有2个，并且实际的表.frm文件在故障点被重命名。|1732395|我的解决方案是去掉单独的CREATE+INDEX语句，使用create+TABLE语句创建它们。在写这篇文章的时候，这已经为我和我的帮助解决了问题，当其他人找到这个帖子时，他们都在挠头。|1732396|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|L|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|M|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

I got this error with MySQL 5.6 but it had nothing to do with Foreign keys. This was on a Windows 7 Professional machine acting as a server on a small LAN. 

The client application was doing a batch operation that creates a table fills it with some external data then runs a query joining with permanent tables then dropping the "temporary" table. This batch does this approximately 300 times and this particular routine had been running week in week out for several years when suddenly we get the Error 1025 Unable to rename problem at a random point in the batch.

In my case the application was using 4 DDL statements a CREATE TABLE followed by 3 CREATE INDEX, there is no foreign key. However only 2 of the indexes actually get created and the actual table .frm file was renamed, at the point of failure.

My solution was to get rid of the separate CREATE INDEX statements and create them using the CREATE TABLE statement. This at the time of writing has solved the issue for me and my help someone else scratching their head when they find this thread.

I tried this in mysql:

<pre><code>mysql&gt; alter table region drop column country_id;
</code></pre>

And got this:

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

Any ideas? Foreign key stuff?

What does mysql error 1025 (HY000): Error on rename of './foo' (errorno: 150) mean?

数据库

服务器

Windows

MySQL

我在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)有什么想法吗？外键的东西？

问mysql error1025 (HY000)：重命名'./foo‘时出错(errorno: 150)是什么意思？
EN

回答 11

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问mysql error1025 (HY000)：重命名'./foo‘时出错(errorno: 150)是什么意思？EN

回答 11

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问mysql error1025 (HY000)：重命名'./foo‘时出错(errorno: 150)是什么意思？
EN