Top "Mysql-error-1025" questions

Error 1025 - Error on rename of '%s' to '%s' (errno: %d)

Error renaming a column in MySQL

How do I rename a column in table xyz? The columns are: Manufacurerid, name, status, AI, PK, int I want …

mysql database alter-table mysql-error-1025
MySQL Removing Some Foreign keys

I have a table whose primary key is used in several other tables and has several foreign keys to other …

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

I tried this in mysql: mysql> alter table region drop column country_id; And got this: ERROR 1025 (HY000): Error …

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

So I am trying to add a primary key to one of the tables in my database. Right now it …

mysql sql phpmyadmin innodb mysql-error-1025
Renaming foreign-key columns in MySQL

We're trying to rename a column in MySQL (5.1.31, InnoDB) that is a foreign key to another table. At first, we …

sql mysql foreign-keys mysql-error-1025
unable to drop the foreign key

I would like to drop the foreign key in my table but been into this error message mysql> alter …

mysql foreign-keys foreign-key-relationship mysql-error-1025
Problem adding Foreign Key using Alter Table with existing MYSQL Database - can't add it! Help!

I have a production database where I have renamed several column's that are foreign keys. Obviously mysql makes this a …

mysql foreign-keys alter-table mysql-error-1005 mysql-error-1025
Changing MySQL primary key when foreign key contraints exist

I have two already-existing tables which look (in part) roughly like this: CREATE TABLE parent ( old_pk CHAR(8) NOT NULL …

mysql foreign-keys primary-key constraints mysql-error-1025
How do I delete a foreign key constraint in SQLAlchemy?

I'm using SQLAlchemy Migrate to keep track of database changes and I'm running into an issue with removing a foreign …

python mysql foreign-keys sqlalchemy mysql-error-1025
Can't remove indexed column, ERROR 1025 (HY000): Error on rename of .. to .. (errno: 150)

I am having trouble removing a column which is indexed. I dont really understand what is happening as I usually …

mysql mysql-error-1025