TRANSACTION 0 5564387, ACTIVE 0 sec, process no 1619, OS thread id 2957499248 updating or deleting, thread declared inside InnoDB 499ġ7 lock struct(s), heap size 2496, 9 row lock(s), undo log entries 2
#Cara registrasi navicat for mysql update
Removing the key constraint with user_email and attempting to update the value in user results in the same error but for the next alphabetical user child table, so I don't believe it is a table-specific error.Īdding in the results from SHOW ENGINE INNODB STATUS:. I have a feeling I must be missing something obvious here.
However, when I attempt to update a user.uid value, it results in the following error, rather than cascading the uid change to the child tables: #1452 - Cannot add or update a child row: a foreign key constraint fails (`accounts`.`user_email`, CONSTRAINT `user_email_ibfk_2` FOREIGN KEY (`uid`) REFERENCES `user` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE)
When I delete a user from user, all of the child constrained entries are removed. These are all tied to the parent user table by a foreign key, uid, with all of the parent and child keys being int(10).Īll of the child tables have a uid value with a foreign key constraint pointing to user.uid, and set to ON DELETE CASCADE and ON UPDATE CASCADE. I have a set of InnoDB user tables in MySQL that are tied together via foreign key the parent user table, and a set of child tables that store email addresses, actions, etc. This seems to be a common error, but for the life of me I can't figure this out.
0 kommentar(er)
