Could anyone please show me how to update a dataValue each time a data in another database changes its value ?
Here is a screenshot of my 2 databases I would like that;
Each time a value in database1-table1 is changing,
It sends a trigger to change the age value in database2-useragetable
I attempt to create a trigger from this link.
Using Trigger to update table in another database
And Here is the code and the screenshot of it.
AFTER UPDATE ON table1.value FOR EACH ROW BEGIN UPDATE TABLE database2.useragetable SET age = NEW.value WHERE no = NEW.no END;