Hi I'm trying to create a trigger
the trigger avant will be to update the worker union number.
my table looks like this -
worker(id,salary,union )
I wont the trigger to take action after I will update a worker salary.
I did this but it don't work
HELP Plz..
CREATE OR REPLACE TRIGGER update_status AFTER UPDATE on worker of salary
FOR EACH ROW
BEGIN
update worker set union = 9;
END update_status;
you want to update the entire table each time any row is updated ?
you want to update the entire table each time any row is updated ?
no, only if I update someone salary I wont to update is UNION
simply put a where clause to your code.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.