I have a web app with angular in the front and java in the back, the database with mySQL, the thing is that when entering a record in a table, one trigger updates the field of another, it is a Boolean field.
I mean, when inserting a data in the table it takes an id from another in a select, so what it does is modify the item in the other table and put it as not available so that nobody else can select that id of item.
Up there normal, what happens is that the change in the table that was modified with the trigger is not reflected in the view if not until I return to run the backend, I mean if I make a change directly in the base of data or I do inserts from console these changes are not seen in the front, then it is my turn to run the back and if the changes are seen ...
Is there any way that the changes can be seen when changing them in the bd or is this something that only happens in development? When you upload it to production, would not that happen?