# 1025-将’./database/# sql-2e0f_1254ba7’重命名为’./database/table’时出错(errno: 150)

因此，我试图添加一个主键到我的数据库中的一个表。现在它有一个这样的主键:

PRIMARY KEY (user_id, round_number)

其中 user _ id 是外键。

我试着把它改成这样:

PRIMARY KEY (user_id, round_number, created_at)

我在 phpmyadmin 中通过单击表结构视图中的主键图标来完成此操作。

我得到的错误是:

#1025 - Error on rename of './database/#sql-2e0f_1254ba7' to './database/table' (errno: 150)

它是一个带有 InnoDB 表引擎的 MySQL 数据库。

106862 次浏览
小开
最佳答案

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 SHOW ENGINE INNODB STATUS and then look at the LATEST FOREIGN KEY ERROR section.

小开

For those who are getting to this question via google... this error can also happen if you try to rename a field that is acting as a foreign key.

小开

As was said you need to remove the FKs before. On Mysql do it like this:

ALTER TABLE `table_name` DROP FOREIGN KEY `id_name_fk`;


ALTER TABLE `table_name` DROP INDEX `id_name_fk`;
小开

To bypass this in PHPMyAdmin or with MySQL, first remove the foreign key constraint before renaming the attribute.

(For PHPMyAdmin users: To remove FK constrains in PHPMyAdmin, select the attribute then click "relation view" next to "print view" in the toolbar below the table structure)

小开

If you are trying to delete a column which is a FOREIGN KEY, you must find the correct name which is not the column name. Eg: If I am trying to delete the server field in the Alarms table which is a foreign key to the servers table.

  2. Look for the CONSTRAINT `server_id_refs_id_34554433` FORIEGN KEY (`server_id`) REFERENCES `server` (`id`) line.
  3. ALTER TABLE `alarm` DROP FOREIGN KEY `server_id_refs_id_34554433`;
  4. ALTER TABLE `alarm` DROP `server_id`

This will delete the foreign key server from the Alarms table.

小开

I had this problem, it is for foreign-key

Click on the Relation View (like the image below) then find name of the field you are going to remove it, and under the Foreign key constraint (INNODB) column, just put the select to nothing! Means no foreign-key

enter image description here

Hope that works!

小开

If you are adding a foreign key and faced this error, it could be the value in the child table is not present in the parent table.

Let's say for the column to which the foreign key has to be added has all values set to 0 and the value is not available in the table you are referencing it.

You can set some value which is present in the parent table and then adding foreign key worked for me.


提交答案