Software Development

I need to rename one column in 170 tables in a MySQL database and its going really slow.

The columns all have an index plus a foreign key on them, would dropping the index/temporarily removing the foreign key speed up the process?

is a duplicate

This question has been asked before and has already been answered. It should be marked as a duplicate.

Please enter the URL of the proposed duplicate in the details field below.

not constructive

This question cannot be answered in a way that is helpful to anyone. It's not possible to learn something from possible answers, except for the solution for the specific problem of the asker.

Communities

Comments on Can renaming a MySQL column be sped up by dropping indexes or foreign keys?

Can renaming a MySQL column be sped up by dropping indexes or foreign keys?

1 comment thread