I have a master table and around 60 to 70 child tables, all are InnoDB tables and have foreign key relationships with the master table.
Foreign key relations are On-Delete Cascade and On-Update No-Action.
My doubt is when any update happens to the master table, will all child tables get checked and then the update occurs, or update will independently happen on master table.
I want to know how update/delete will happen when there are foreign key relations to child tables.
- MySQL version is 5.0.24
- OS is Windows
I wanted to know, when any update happens, will the update query cross verify all child tables and then update the master table, so that will the update query will take time to update master table compared to update on normal table which is not having any foreign key relations