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…
One response to “MySQL – Alter table-change datatype of column with foreign key”
Add this to get
foriegn keys relationships of a table with its childs with
SELECT `TABLE_SCHEMA`, `TABLE_NAME`, `COLUMN_NAME`, `REFERENCED_TABLE_SCHEMA`, `REFERENCED_TABLE_NAME`, `REFERENCED_COLUMN_NAME` FROM `INFORMATION_SCHEMA`.`KEY_COLUMN_USAGE` WHERE `TABLE_SCHEMA` = “my_schema” AND `REFERENCED_TABLE_NAME` = “my_parent_table”