I have a requirement where i need to update 6 tables. Each table contains a status column. I need to update the status column of those rows where id = 1.
So, should i go for manually fetching all rows from each table and update it in a single class? or is there any other easy and suitable way to update the tables?
It doesn't sound like there is a relationship between the tables other than having a status column (which is not really a relationship). I would address each one independently rather than trying to tie things together where there is no relationship.