A Unique Foreign Key issue in MySQL 8.4
Kedar
Recently, a friend reached out to me for help after encountering an error while restoring a MySQL dump during an upgrade from MySQL 8.0 to 8.4. The error read: At…
Browsing Tag
foreign key
2 posts
MySQL – Alter table-change datatype of column with foreign key
Schema alteration is a big headache especially when it has already reached to production and things get worse when the relations are involved.Below is a short example for altering tables…